muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
I am being flummoxed by this formula where I cannot get the cell reference to be dynamic, can someone please help me understand how to fix this?
=IF(ISBLANK(INDIRECT("'"&Variables!$F$2&"'!"&"A8")),"",INDIRECT("'"&Variables!$F$2&"'!"&"A8"))
So what i'm trying to do is fill in the variable sheet names cell A8 and fill it in if it's not blank. However, if I drag this, the "A8" is static vs filling in A9 or B8 depending on where I drag it to. Can someone help me make this dynamic so that it still pulls the data from the respective sheet but can be filled any way?
Thanks in advance for your help here.
=IF(ISBLANK(INDIRECT("'"&Variables!$F$2&"'!"&"A8")),"",INDIRECT("'"&Variables!$F$2&"'!"&"A8"))
So what i'm trying to do is fill in the variable sheet names cell A8 and fill it in if it's not blank. However, if I drag this, the "A8" is static vs filling in A9 or B8 depending on where I drag it to. Can someone help me make this dynamic so that it still pulls the data from the respective sheet but can be filled any way?
Thanks in advance for your help here.