Nested Index Match Formula

tarastephanie

What's wrong with my formula?

It's showing #unparseable

KPH

#UNPARSEABLE

Cause

The formula has a problem which prevents it from being parsed and interpreted. This can happen for many reasons, such as misspelling, incomplete operators, using the wrong case for a column name, or using single quotes instead of double quotes.

Resolution

Ensure that all column names are spelled correctly in cell references, operators are being used correctly, and any text strings in the formula are surrounded by double quotes (" ").

Source: https://help.smartsheet.com/articles/2476176-formula-error-messages

If you are still stuck, please share the formula - a second pair of eyes may be able to see the issue.