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... :-)