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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
How can I insert a chart on a separate sheet on the workbook 2
Fill Series for Lookup 2
Help to create a macro 2
3-D References 4
how to populate many worksheets in a workbook 4
V/HLookup 3
Lookup a particular cell in another excel workbook 1

Back
Top