Index/Match Leaving Blanks + "#NO MATCH"

Willow Williams
edited 08/18/23 in Formulas and Functions

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!