Hi,
Try this:
=INDIRECT("'"&A2&"'!C5")
or this (if the C5 reference is variable):
=INDIRECT("'"&A2&"'!"&CELL("address",C5))
Regards,
KL
"amaranth" wrote in
message ...
I've got a workbook with 80 worksheets in. The first worksheet (INDEX)
has a vertical list of all the worksheet names. I want to lookup a cell
in each of the worksheets using the vertical list and return it to a
column on the INDEX sheet. However, I don't want to use a VLOOKUP as
this would be time consuming. What I'd ideally like is a formula along
the lines of:
='A2'!C5
where A2 is one of the worksheet names, and C5 is the cell on that
worksheet that I want to return. Is there any easy way to do this?
--
amaranth
------------------------------------------------------------------------
amaranth's Profile:
http://www.excelforum.com/member.php...o&userid=26031
View this thread: http://www.excelforum.com/showthread...hreadid=393812