For when C5 is a variable you can simply use:
=INDIRECT("'"&A2&"'!" & C5)
instead of:
=INDIRECT("'"&A2&"'!"&CELL("address",C5))


"KL" wrote in message ...
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