Index Match dilemma

I am attempting to access info from another sheet. I have a list and need to attach the correct person to the item. I've tried 2 different formulas, but it's only bringing back the 1st person that it found, not a different person for each item.

Here are the 2 formulas that I've tried. What am I missing?

=INDEX({TO CHECKOUT Puller}, MATCH([CHARAC FABRIC TO#]@row, {TO CHECKOUT TO#}))

=IFERROR(INDEX({TO CHECKOUT Range 2}, MATCH([CHARAC NOTIONS TO#]@row, {TO CHECKOUT TO#})), " ")

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

VLOOKUP stops on the first match the same as INDEX/MATCH.

Try specifying an exact match in your INDEX/MATCH by placing a zero in the third portion of the MATCH function.

All comments

Paul Newcome

INDEX/MATCH will only pull the first row where a match is found. Are you able to provide screenshots for reference?

Blanche Marie Lewis

Well that won't work for me then. Bleh! Do I need to stick with VLookUp? I can't provide a screenshot because of security concerns.

Paul Newcome

VLOOKUP works the same way. Are you able to provide a mockup with dummy data?

Blanche Marie Lewis

No. With vlookup it matched it correctly.

Paul Newcome

VLOOKUP stops on the first match the same as INDEX/MATCH.

Try specifying an exact match in your INDEX/MATCH by placing a zero in the third portion of the MATCH function.

Blanche Marie Lewis

Adding the zero in the 3rd portion of the MATCH function worked. Thank you!

Paul Newcome

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