Odd vlookup behavior

Hello,

I have configured two columns in a sheet with a vlookup column formula. The formula references another sheet in the same workspace and initially works fine. When a new row is added via a form, the two columns show a #nomatch error. I verified the key and the data I'm looking for exists in the reference table so I'm not sure why it is not bringing back any data.

I deleted the vlookup column formulas and reentered them and it worked for the row that was showing #nomatch. When a row was added via the form after redoing it, I encountered the same issue.

Any help would be appreciated.

Thank you,

Find more posts tagged with

Accepted answers

Devin Lee

VLOOKUP can have issues when new rows are added due to having the column number in the formula. Start using INDEX/MATCH instead. https://help.smartsheet.com/function/index

All comments

Devin Lee

VLOOKUP can have issues when new rows are added due to having the column number in the formula. Start using INDEX/MATCH instead. https://help.smartsheet.com/function/index

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.