Difficult Excel Question

R

rthakrar49

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

[email protected]
 
B

Bob Phillips

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

--

HTH

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

Jason Morin

Try:

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

where the sheet name is located in A1.

HTH
Jason
Atlanta, GA
 
Top