Using a cell to reference sheetname in vlookup function
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. |
Using a cell to reference sheetname in vlookup function
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. |
All times are GMT +1. The time now is 08:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com