Issue with VLOOKUP

edited 03/14/24 in Formulas and Functions

I input a vlookup formula on my Smartsheet, and some of the values are not returning a match even though they are a valid option from my reference list. Below is the formula I'm using in my sheet.

Here is the data table I'm referencing for the values. As you can see, the bottom two values are included in my reference, but it's still returning #NO MATCH.

I'm not sure what I'm missing or doing incorrectly. Does anyone have any suggestions on how to fix this?


  • Scott Orsey
    Scott Orsey ✭✭✭✭✭

    Hi... I suspect the issue is that some of your numbers start with "0" so those may be treated as text. VLOOKUP requires that the table be sorted in ascending order, so you could check that.

    For a better fix, I would recommend using INDEX(MATCH) instead of vlookup. The sort won't matter, and it's a more reliable way to look things up.

    Good luck!

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!