Reference previous worksheet within VLOOKUP
 

I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March
09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2,
INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending
on how I tinker with the formula. Not sure what is missing. Using EXCEL
2000.

Any assistance would be appreciated. Thank you.

Reference previous worksheet within VLOOKUP
 

On Fri, 17 Apr 2009 10:54:11 -0700, Alex Mackenzie
wrote:

I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March
09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2,
INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending
on how I tinker with the formula. Not sure what is missing. Using EXCEL
2000.

Any assistance would be appreciated. Thank you.


Try this formula:

=VLOOKUP(A2,INDIRECT($T$2&"A2:B100"),1,FALSE)

or

=VLOOKUP(A2,INDIRECT($T$2&"A2:B100"),2,FALSE)

if you want values from the B column to be returned.

Note the " around A2:B100 and that the 1 (or the 2) is outside the
call to INDIRECT rather than inside as in your formula.

Hope this helps / Lars-Åke

Reference previous worksheet within VLOOKUP
 

=VLOOKUP(A2,INDIRECT("'"&T2&"'!A2:B100"),2,0)


"Alex Mackenzie" wrote:

I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March
09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2,
INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending
on how I tinker with the formula. Not sure what is missing. Using EXCEL
2000.

Any assistance would be appreciated. Thank you.