Vlookup reference a worksheet
 

=VLOOKUP(F3,INDIRECT($A$1&"!$A$2:$J$3639"),2,FALSE )
where cell A1 contains the Sheet Name (case insensitive)
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"Mark Brown" wrote:

I am attempting to use Vlookup to do a multiple lookup.

I have 7 different worksheets and would like the worksheet names to be one
variable and the worksheet to be a second variable, the vlookup formula is
below. $f$3 is a list of months. I would like to find a way to set the
'a26' to be a variable, so that I can look in different worksheets- depending
on what is input. Each worksheet is an individual person that I need to look
up data on.

=VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,)

This should do the trick - if you other workbooks are all open

=VLOOKUP($F$3,INDIRECT("'"&a26&"'!$A$2:$J$3639"),2 ,)

"Mark Brown" wrote:

I am attempting to use Vlookup to do a multiple lookup.

I have 7 different worksheets and would like the worksheet names to be one
variable and the worksheet to be a second variable, the vlookup formula is
below. $f$3 is a list of months. I would like to find a way to set the
'a26' to be a variable, so that I can look in different worksheets- depending
on what is input. Each worksheet is an individual person that I need to look
up data on.

=VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,)