ADDRESS Function

Q

QC Coug

I posted an item below. I think the Address function is creating the formula
I need, but is there a way for it to return the value in the cell instead of
the formula for the cell?

From Help:
=ADDRESS(2,3,1,FALSE,"EXCEL SHEET") is an absolute reference to another
worksheet ('EXCEL SHEET'!R2C3)
 
G

Gary''s Student

Its just another function:

if B2 contains:
=ADDRESS(2,3,1,FALSE,"EXCEL SHEET")

then you will see:
'EXCEL SHEET'!R2C3
in the cell.


In B3 put:

=INDIRECT(B2,A1)

and B3 will show the contents of the target.
 
Top