I am doing a VLOOKUP, but when you select the sheet you wish to look at, I
would like the name to chance depending on a name supplied by a cell. If
anyone can solve this, please e-mail me

=VLOOKUP(A1,INDIRECT("'"&A2&"'!A1:H100"),3,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


" m
wrote in message ...
I am doing a VLOOKUP, but when you select the sheet you wish to look at, I
would like the name to chance depending on a name supplied by a cell. If
anyone can solve this, please e-mail me

Try:

=VLOOKUP(---,INDIRECT("'"&A1&"'!A:D"),---,---)

where the sheet name is located in A1.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am doing a VLOOKUP, but when you select the sheet you
wish to look at, I
would like the name to chance depending on a name
supplied by a cell. If
anyone can solve this, please e-mail me


.