Index/Match Formula Behavior

Hello,

I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return 'no match' as expected. Instead, it displays the last entry in the reference range.

Formula in cell Category Index/Match

=IFERROR(INDEX({Category}, MATCH([Equipment_ID]@row, {ID})), "The issue was reported via the generic form without specifying equipment ID")

The reference range

Could you please assist me in resolving this issue?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!