Index Match referencing a contact list to return a contact.

tylerjewell ✭✭
edited 08/07/23 in Formulas and Functions


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!