using a cell that contains a reference

[Guest]

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.

 

[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

 

[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)