Help with formula

Options

Hello,

I have been trying to fix the following formula in Smartsheet but I continue getting the #UNPARSEABLE error message. Can someone help me fix it?

=IFERROR(INDEX({Reference Range 4}, MATCH([Job Level]@row, {Reference Range 5},0)MATCH(Region@row, {Reference Range 6},0)),0)


Reference Sheet:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!