The result of index and match formula is wrong

I have a material number and material description in the source sheet which I want to use match & index formula to identify the material description in another sheet, I use this formula:

INDEX({Test Item Database Range 4}, MATCH([PCX Supplied Material#]@row, {Test Item Database Range 2}))

However, the result starts to going wrong from 3rd row, snapshot of the destination and source sheet as below, pls help to check and advice, thank you~

Source Sheet

Destination Sheet

Find more posts tagged with

Formulas

Accepted answers

All comments

Beth Fantozzi 1

Could this be solved by adding the "search type" (typically 0) in the formula? I've seen instances of my formulas not working correctly when I miss this. In your case, adding in the 0 would look like this:

=INDEX({Test Item Database Range 4}, MATCH([PCX Supplied Material#]@row, {Test Item Database Range 2},0))

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