ExcelBanter - Difficult Excel Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Difficult Excel Question (https://www.excelbanter.com/excel-discussion-misc-queries/10190-difficult-excel-question.html)

[email protected]

Difficult Excel Question

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

Bob Phillips

=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

Jason Morin

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

.

All times are GMT +1. The time now is 05:26 AM.