Issue with VLOOKUP

kayseyk

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

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!