Index Match referencing a contact list to return a contact.

tylerjewell

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.

Paul Newcome

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