Index and Match returns one incorrect response...all others correct

I have a service request sheet with an index/match formula to assign a person based on request type. My formula works for all request types except "External Communications" - it assigns the wrong person. I tried creating a new "Assigned To Lookup" reference sheet, manually entering all fields, and yet the error persists.

=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}))

Find more posts tagged with

Cell linking

Accepted answers

Mark Cronk

Try:

=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}, 0))

The 0 says your list isn't sorted so it needs to find an exact match.

Work?

Mark

All comments

Mark Cronk

Try:

=INDEX({Assigned To Lookup Range 1}, MATCH([Request Type]@row, {Assigned To Lookup Range 2}, 0))

The 0 says your list isn't sorted so it needs to find an exact match.

Work?

Mark

Gabby Nepomuceno

@Mark Cronk Yes! Thank you! It was driving me nuts trying to figure out why it wasn't working. Our comms team thanks you! -Gabby

Mark Cronk

Hi Gabby, Glad you found a solution. Thank you for contributing to the community and for the vote up.

Mark

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.