formula for comparison

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?

Try VLOOKUP...

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

Adjust the range accordingly.

Hope this helps!

In article <72D7145C-866E-4C8E-A880-F9BD6F99605A@microsoft.com>,
"sweetsue516" <sweetsue516@discussions.microsoft.com> 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?

Wonderful!

Thank you

"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?