Problems refreshing a VLOOKUP with new data

Hi,

A couple of weeks ago I successfully created a VLOOKUP between 2 sheets, and updated it with new data last week.

However, today when I tried to do the same refresh, I am consistently getting #NOMATCH whenever I reference the new sheet. I tried deleting all the sheet references, making new references, clearing out all the formulas, etc... However I can still successfully link to last week's sheet - just not the new one 🤨

Problem formula:

Successful formula:

I confirmed there are values that should link in the problem formula above. Help please!

Find more posts tagged with

Accepted answers

All comments

KPH

Does your new sheet have an error in it somewhere? I don’t mean the formula, but the sheet with the data. With smartsheet formula if the column that is being looked through for a match has an error in it, it throws off the whole thing, even if there are cells that do match. Could that be the problem?

CatSusk

I wound up recreating the new sheet yesterday and it finally worked, so I think you are correct. This sheet was imported from Excel - I made sure to change the number column format first in excel to "number" instead of "number stored as text" - that's probably what caused the issue.

KPH

Glad you have it sorted. Thanks for letting me know.

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.