Can I use an INDEX formula to retrieve value from another INDEX Formula?

Options
Jose Vale
Jose Vale ✭✭✭

Hello,

I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error.

They are as follows:

"IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retrieves the value I want.

"=IF([Nov-19]110 = 0, 0, INDEX($[Jan-19]$189:$[FY50]$189, 1, [Nov-19]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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!