Can I use an INDEX formula to retrieve value from another INDEX Formula?
Hello,
I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error.
They are as follows:
"IF([Nov19]188 = 0, 0, INDEX($[Jan19]$119:$[FY50]$119, 1, [Nov19]188))"  this one works and retrieves the value I want.
"=IF([Nov19]110 = 0, 0, INDEX($[Jan19]$189:$[FY50]$189, 1, [Nov19]110))"  retrieves #INVALID VALUE and line 189 is where the above formula is.
Is it possible to use an INDEX formula to retrieve value from another INDEX Formula?
Best Answer

Yes. That was going to be my next question. Glad you got it figured out! 👍️
Answers

What exactly is in [Nov19]110?

I have figured out the problem since, the range $[Jan19]$189:$[FY50]$18 included #INVALID VALUEs which led the formula into error.

Yes. That was going to be my next question. Glad you got it figured out! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!