使用间接和如果函数和动态范围。

I'm trying to combine the INDIRECT and IF functions together so I can drag formulas down without getting a #REF! error when I run my macro. Currently, I have one sheet that has all the IF functions and another sheet that it refers to. The current IF function is:I'm trying to combine the INDIRECT and IF funct