Index/match not working and I can see be reason why!

I am index/ matching from another sheet and it says no match, but there is clearly a match!

I have moved the information into the same sheet to see if it would pick it up and it does but only some rows. I don't get it!

Best Answer

  • SJO
    SJO ✭✭✭
    Answer ✓

    Apologies for the delay! I have figured it out. The match column on the reference sheet had a hidden comma at the start of the number that was only visible when I double clicked the cell.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!