Index Match referencing a contact list to return a contact.

Hello,

I have a project intake take, and I want it to generate a Platform Manager based on the platform that is entered. The sheet I'm referencing has a list of platforms with the corresponding contact next to it.

Intake sheet: Platform, Platform Manager (contact field)

Reference Sheet: Platform, Platform Manager (contact field)

=INDEX({Contact References Range 6}, MATCH(Platform@row, {Contact References Range 2}))

It's returning #contact expected.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Make sure both columns are set as contact type columns. Sounds like the column on your reference sheet may not be.

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.