Looping through columns finding name Then doing a Function vba excel

See more:

VB

I have a excel Where i Have 6 different names as variables . The varibles are dynamic . They end up in different rows everytime i do this function . Can someone please help me on how to go about Looping through these names . Finding out which name is which . then performing a different calculation depending on what the "name " is . The names always end up in Column A . They just end up in different rows . So i would like to know how to do a function /macro that looks like this ....... If name = Anna d1=b1*c1 . If name = Harry d1 = b1+c1 ....... Thank you guys . I am new to excel .

<br />
Name <br />
Number<br />
Number <br />
 <br />
Anna <br />
       36.476833<br />
        7.96618557<br />
 if name = Anna Number "times Number" <br />
<br />
Eric <br />
17.451147<br />
5.80342102<br />
if name = Eric Number + Number <br />
<br />
Ronald<br />
21.125067<br />
6.45224857<br />
<br />
If name =  Ronald Number "divided"By Number <br />
<br />
Roxanne<br />
12.071469<br />
2.55927372<br />
 <br />
Harry <br />
0<br />
30.1705704<br />
 <br />
Vallerie<br />
11.67783<br />
0<br />
 <br />
Wally <br />
0<br />
6.81271219<br />
 <br />