VLOOKUP with more than one contact

Kirstine ✭✭✭✭✭✭

I need a formula that when a job is booked in, will check to see if team members assigned to it have liability insurance. I have a separate sheet (Certificates v2.0) with our workers listed and whether their liability is Current or Expired. The following formula works but only when there is a single team member in the Team column. Obviously when there are two contacts in the cell it no longer matches the list in the Certificates sheet, even with 'True' used in my VLOOKUP. Can anyone help please?

=IF(OR(Status@row = "Booked In", Status@row = "Work In Progress"), (VLOOKUP(Team@row, {Certificates v2.0 Liability}, 13, true)), "")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!