Try VLOOKUP...

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

Adjust the range accordingly.

Hope this helps!

In article ,
"sweetsue516" wrote:

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?