help with vlookup across multiple worksheets
Hi!
Try something like this:
G1 = sheet name
=VLOOKUP(A1,INDIRECT("'"&G1&"'!a1:b5"),2,0)
Biff
"jnasr" wrote in message
oups.com...
Hi,
I'm pretty new to using lookup functions. I have a workbook wiuth 96
worksheets, and rather than linking individual cells to each worksheet,
I was hoping I could use a lookup function. I entered the name of each
worksheet on my output page. Is there a way to get the lookup function
to read the data in that cell as the name of the worksheet? Any help
would be appreciated.
Thanks!
|