OK, so I'm trying to set up a simple VLOOKUP.

What I'd like to do is, have the user enter a value in cell A2, tab name in
cell B2, and have C2 return the corresponding value. The problem I'm having
is, how do I get VLOOKUP to search in the tab name as listed in B2? Or do I
need a whole different type of formula?

Don't tell me, it's a SUMPRODUCT of some sort... :-)

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sean Timmons" wrote in message ...
| OK, so I'm trying to set up a simple VLOOKUP.
|
| What I'd like to do is, have the user enter a value in cell A2, tab name in
| cell B2, and have C2 return the corresponding value. The problem I'm having
| is, how do I get VLOOKUP to search in the tab name as listed in B2? Or do I
| need a whole different type of formula?
|
| Don't tell me, it's a SUMPRODUCT of some sort... :-)

My apologies, I should have specified. The tab reference is on another
workbook. I can't seem to get the indirect function embedded in my VLOOKUP.

"Niek Otten" wrote:

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sean Timmons" wrote in message ...
| OK, so I'm trying to set up a simple VLOOKUP.
|
| What I'd like to do is, have the user enter a value in cell A2, tab name in
| cell B2, and have C2 return the corresponding value. The problem I'm having
| is, how do I get VLOOKUP to search in the tab name as listed in B2? Or do I
| need a whole different type of formula?
|
| Don't tell me, it's a SUMPRODUCT of some sort... :-)

Indirect only works on *open* WBs.

However, Laurent Longre has an "Indirect.ext" function which is supposed to
work on closed WBs.
Look he
http://xcell05.free.fr/
And click on the English page, and look for "Indirect.ext".

Harlan Grove also has created something that will work with closed files.
Look he
ftp://members.aol.com/hrlngrv/
And click on "Pull.zip".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Sean Timmons" wrote in message
...
My apologies, I should have specified. The tab reference is on another
workbook. I can't seem to get the indirect function embedded in my
VLOOKUP.

"Niek Otten" wrote:

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sean Timmons" wrote in message
...
| OK, so I'm trying to set up a simple VLOOKUP.
|
| What I'd like to do is, have the user enter a value in cell A2, tab
name in
| cell B2, and have C2 return the corresponding value. The problem I'm
having
| is, how do I get VLOOKUP to search in the tab name as listed in B2? Or
do I
| need a whole different type of formula?
|
| Don't tell me, it's a SUMPRODUCT of some sort... :-)