Multi Select Look up
I'm trying to see if anyone has any ideas of a formula that can been written for the following example.
I'm trying to get the contact(mail) in sheet 2 to populate sheet 1(Approval Seq 1 Contact) column.
There is 2 criteria (Division and Seq.1) on sheet 1 need to match (Division, Sequence #) on sheet 2 to return the contact (Contact (Email) to Sheet 1 (Approval Seq 1 Contact).
Sequence # is a Multi Select (dropdown list)
Thanks for the help
Help Article Resources
Check out the Formula Handbook template!