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.

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.

I just wanted to search a list for a specific name and your response is
exactly what I was looking for. I tried vlookup and it worked. Thank you so
much for your quick response.

smck

"Arceedee" wrote:

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.

OK, I am getting the response I want using vlookup but this can get tedious
depending on the frequency I am quering this list. I would like to know if
anyone has a macro that would give me a popup and ask for input then activate
vlookup that would put the result in the active cell. I can only create basic
macros, I don't know vba so it's a challenge.

Thanks again folks

"smck" wrote:

I just wanted to search a list for a specific name and your response is
exactly what I was looking for. I tried vlookup and it worked. Thank you so
much for your quick response.

smck

"Arceedee" wrote:

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.

How would you want to query the list?

If you want NAFTA in B6 just type in NAFTA

You have left something out in your description.


Gord Dibben MS Excel MVP


On Tue, 2 Feb 2010 12:32:01 -0800, 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.