Using Dynamic Cell Address As Formula Location
On Mar 5, 10:24 pm, "T. Valko" wrote:
What do you mean by: "use the cell address as a formula location"?
Do you want to use that reference in another formula?
Assume the result of that formula is in cell A1.
Since that formula can return either a blank or a text reference you'd have
to test for the blank:
=IF(A1="",value_if_true,....................)
If A1 does contain the text reference then you need to use the INDIRECT
function to reference it: INDIRECT(A1). Since you didn't describe how you
want to use that reference I don't know how to finish the above IF formula.
Biff
wrote in message
oups.com...
I am using the following formula to return cell address $G$16:
=IF(E110,CELL("address",OFFSET(E17,-1,E17)),"")
I wish to then use the cell address as a formula location...cell
address will change depending on the value in E17.
Appreciate any ideas.
Thanks,
Sven- Hide quoted text -
- Show quoted text -
in the example I wish to populate cell $G$16 with something like
$B5*E11
|