Self Reference

Posted by Erick on June 29, 2001 9:42 AM

While working with a formula in a CELL I like to use its owns CELL REFERENCE to look up a value in another sheet in the same location.

Thanks,

From Miami

Posted by IML on June 29, 2001 9:50 AM

I'm not sure if this will help, but you can build vlookup around your formula. Such as,
=VLOOKUP(A1+A2,range,2,FALSE)
where you want to look up the sum of A1 or A2. Is what you want to look up a the result of a formula, or is it manually entered by someone/thing?

Posted by Erick on June 29, 2001 10:09 AM

No, what I need to do is for ex.:

while entering a formula in cell B4 I like to use its cell reference in this case "B4" to see the value of "B4" but in sheet!2

Thanks

Posted by cpod on June 29, 2001 10:16 AM

Perhaps something like this? When placed in B4 on some other sheet will reference B4 on Sheet2:

=INDIRECT("sheet2!" & CELL("address"))

Posted by Aladin Akyurek on June 29, 2001 10:27 AM

That will invariably produce a circular reference.

Aladin