Indirect

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

Guest

Trying to get this indirect reference to work and cant please help

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

Where A1 contains the sheet name (in the form of a number) that I am trying to reference

Thanks!
 
Hi
formula looks o.k. what is the content of cell A1. It has to contain
the sheet NAME (not the index number of the sheet)
 
Carol,

The value entered in A1 has to exactly match the sheet name, and you need to
modify your formula to return a string:

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

HTH,
Bernie
MS Excel MVP
 
Hi
i just recognized you missed the closing apostrophe. Try
=INDIRECT("'" & A1 & "'!A2")
 
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

Set non-continuous PrintArea via Function / Name 0
Vlookup and return sheet name also 2
INDIRECT Function 9
Indirect Function() - summing across sheets 7
Vlookup and Indirect 0
Referencing External files with slightly different names 4
sums of range within sumproduct 4
Indirect function 5

Back
Top