Using a cell to reference a sheetname in a workbook, how can you use
that cell as the sheetname part of a vlookup function?

For example, let's say cell A1 says "Products - 2001" Rather than
physically selecting the range of data in the "Products - 2001"
worksheet, is there a way to reference cell A1 in the vlookup function
to lookup the data on that sheet?

Thanks.

I think you are wanting the Indirect function. A quick search of this forum
for "indirect" should get you going in the right direction if I understood
your quetion correctly....
--
HTH...

Jim Thomlinson


"jnasr" wrote:

Using a cell to reference a sheetname in a workbook, how can you use
that cell as the sheetname part of a vlookup function?

For example, let's say cell A1 says "Products - 2001" Rather than
physically selecting the range of data in the "Products - 2001"
worksheet, is there a way to reference cell A1 in the vlookup function
to lookup the data on that sheet?

Thanks.