J
jnasr
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.
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.