How can I do a 3-D Lookup through a workbook?

C

cbaugher

I have 10 or 15 identically formatted sheets in a workbook,each with data
about separte orchard blocks on our farm. On Sheet 1, I would like to put a
sheet name in cell A1 and return a cell value from the named sheet in cell
A2, as in a lookup function, only looking back through the workbook.
 
D

Dave Peterson

Maybe something like:

=INDIRECT("'" & A1 & "'!c9")

This will return the contents of C9 from the sheet whose name is in A1.

(I got confused about how A2 fit in.)
 
Top