Index/Match Leaving Blanks + "#NO MATCH"

Willow Williams

I apologize if this posts twice... I am a relatively new Smartsheet-er experimenting with the capabilities of the Index/Match function. I have two sheets, one that tracks project status, and one that I would like to link to the first, showing live project status updates by matching the ID # columns. I have created a formula that works well, however 4 of my rows in the 2nd sheet appear blank, and 1 returns "No Match". I have copied and pasted the IDs exactly between the two sheets, and the rest of the rows work just fine.

Formula: =INDEX({Status Ref Range}, MATCH([HBK ID#]@row, {ID Ref Range}))

2nd sheet:

Reference:

Thanks!

Paul Newcome

Use a zero in the third portion of the MATCH function to indicate a specific match. The default when left out is an approximate match and can cause these issues.

=INDEX({range}, MATCH("text", {range}, 0))