Index/Match Returning No Match When it Has A Match

Kelly Pratt
Kelly Pratt ✭✭✭✭✭
edited 12/07/22 in Formulas and Functions

I keep running into issues in one of my SS environments where the Index Match function is returning a #NO MATCH. What's interesting is I will have it in one column in a sheet and it works, then in the next column I am using the same formula but the only difference is I am changing the INDEX range which then produces a NO MATCH. This doesn't make sense to me since it's working on the first one.

In another scenario, I am using the Index/Match in a column formula and it works in one row but not the next when I am literally copying and pasting the value to match to from the sheet I am looking at.

Any ideas why this could be occurring?

Here is the formula I use:

=INDEX({Program}, MATCH([Project Name]@row, {Intake Project Name}), 0)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!