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")
 
Back
Top