Index Match - Just when I thought I had it figured out

Davisc8

So I am using a formula on a smartsheet, works flawlessly:

=IFERROR(INDEX({PERFECTION YARD CHECK TAG}, MATCH(VIN@row, {PERFECTION YARD CHECK VIN}, 0)), "")

I use it on a few different customer sheets and it works on them.

Then on one sheet - I get this error - it has to be something with how the sheet is set up I think.

Any suggestions ?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Double check the [VIN] column is definitely spelled to match what you have in the sheet and doesn't have any hidden spaces or anything in the column name.

Davisc8

Thank you, that did lead me in the right direction. For some reason I was not able to type in the reference data, I had to actually select the reference data from managed references. I tried pasting the formula from another page which does not work even though the references are the same destination.

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.