Index Match return "NO MATCH" when it should match


Hi, I started using Smartsheet recently to convert an old Excel spreadsheet. I have gotten better with help of multiple community posts, but I juste encountered a problem thet does not make sense in my opinion.

I am working with references.

In the "Actual Gate" column, I successfully return the value from a referenced table depending on the latest date inserted in a range of date cells.

Then, in the Next Gate column, I want to return the Next Gate according to the value in the actual gate column.

This should be a simple Index/Match functions, but it returns "NO MATCH"

I tried to separate the formula but even when I use one cell to index the 5th value from the reference and another cell to match the value indexed above in the same referenced, it still returns "NO MATCH"... I have joined some screenshots

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!