using a cell that contains a reference

  • Thread starter Dim DumbAss as Name
  • Start date
D

Dim DumbAss as Name

For some reason I can't find my first posting? Anyway....
I am trying to use the address that is in P3 'Exited!'!$E$10.
Indirect("P3") returns 'Exited!'!$E$10, but I need the value that is in
'Exited!'!$E$10.

I am trying to evaluate the value from 'Exited!'!$E$10 against q3 to see if
they are the same, but I have to use reference in p3. Any ideas. Thanks.
 
J

JulieD

Hi

try
Indirect(P3)
and
when you type
'Exited!'!$E$10
into P3
you have to type
''Exited!'!$E$10

ie an extra apostraphe at the start of the cell - a better solution would be
to get rid of the ! out of the sheet name and then you wouldn't need to
enclose the sheet name in apostraphes at all.

Cheers
JulieD
 
D

Dave Peterson

Just a hint.

If you rename (temporarily) your worksheet to A, then typed your formula, then
renamed it back, excel would have built the formula correctly.

(sometimes it's easier letting excel do the heavy lifting/remembering)
 
Top