View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sven.halb@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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