Using Match Function with Multiple Contact Column

01/27/21
Answered - Pending Review

Hello, I need to lookup a value in a table when a specific contact matches. I tried using match/index, however the column containing the contacts in the lookup table allows multiple contacts which I am unable to determine how to use match with multiple contact listings.


The use case is as follows: Send an email alert to all assigned managers in a particular unit when a ticket is opened by someone in their unit.


Any assistance is appreciated,

Thanks!

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    It is currently not possible to use a formula to populate multiple contacts.

    thinkspi.com

  • Thanks Paul,

    I may have been unclear, I am not trying to populate a multiple contacts field, but I am trying to lookup a value if a contact exists in a multiple contact field. The HAS function works well to tell me that the name exists in the column, but I am unable to determine how to combine this with a Match/Index or VLookup.


    Thanks!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try an INDEX/COLLECT instead.

    =INDEX(COLLECT({Range to pull from}, {Contact Column}, HAS("Contact", @cell)), 1)

    thinkspi.com

Sign In or Register to comment.