formula for comparison

S

sweetsue516

I have a spreadsheet that needs a formula for looking up a name of a fund in
one column (A) then if found in that column equal column B.

Can anyone help?
 
D

Domenic

Try VLOOKUP...

=VLOOKUP("FundName",$A$1:$B$100,2,0)

Adjust the range accordingly.

Hope this helps!
 
Top