Index/Match Results Return only matching first entry on list

I"m using Index match to return a contact based on the department entered in another cell. The department entries are copied from the drop down list in the other sheet so they should be exact matches. For some reason it's only returning a value for the first entry on the list, but the others give a "no match" error.

This is the formula I use: =INDEX({Department Contact List Range 1}, MATCH([Component or Support Department]@row, {Department Contact List Range 2}), 0)

screenshots attached below:

Find more posts tagged with

Accepted answers

Paul Newcome

Move the second to last closing parenthesis to the very end.

You have:

), 0)

Try instead:

, 0))

All comments

Paul Newcome

Move the second to last closing parenthesis to the very end.

You have:

), 0)

Try instead:

, 0))

MegBLLC

That worked! How embarrassing! 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.