Sounds like you mean vlookup but you need to give more info as to what you
are doing.

"smck" wrote:

I have a list of names in Column A e.g.
A B
NAFTA
OPEC
CCNA
WIF

and want to query that list and have the result display in cell B6 e.g.
NAFTA. I don't know which cell the information is in but wish to search
A1:A4. which one of the functions should I be using. I know I can do =A1 from
cell B6 but I want to search the range automatically. Thanks in advance for
your help.