Issue with VLOOKUP

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?

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.