Using Dynamic Cell Address As Formula Location
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
|