I have used a formula to construct a piece of text that looks like an address eg $C$1 in cell A1. I now want to use that value as an address in a formula in cell F1 eg I would like the value stored in $C$1 to appear in cell F1 by referencing A1. I do not know before hand that A1 has $C$1 in it since, depending on other variables, A1 might evaluate to some other piece of text that is a different address.
How do i reference the address that is a value in a cell in a formula in another cell in Excel.?
This is called an indirect reference
=indirect(a1) in cell F1 equals whats in c1 when a1=$c$1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment