Index Match Issue

I have an index/match formula pulling data from a column based on item ID, which is a unique identifier. The index/match today pulled values for every value after the desired ID. Here's the formula text:

=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 1), 0), "")

It is a column, formula, and the ranges selected are the entire columns in the lookup sheet. I made identical formulas for 3 other functions with this same text and did not have any errors happen, so I'm not sure why this one is not working. Any feedback would be greatly appreciated.

Thank you.

Find more posts tagged with

Accepted answers

SteyJ

It looks like you're using an optional column index. Try without it:

=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, 
MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 0)), "")

All comments

SteyJ

It looks like you're using an optional column index. Try without it:

=IFERROR(INDEX({North America CAR Tracker Update Request Range 4}, 
MATCH([ID Number]@row, {North America CAR Tracker Update Request - ID}, 0)), "")

sabbott00

Jacob,

That worked thank you!

SteyJ

https://community.smartsheet.com/discussion/comment/419525#Comment_419525

Happy to help!

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.