VLOOKUP on DropDown Multiselect

Hi All,


Does anyone know if there is a way to use VLookup with values selected from a DropDown with multiple selection?

This is my example:

I have a grid with all contacts dived by studios.

I use a Vlookup formula in another grid for orders where though a Form people choose where to send the order.

My problem comes up once the order goes to multiple studios and instead of receive the emails for both (ie aaa@aaa.com, bbb@bbb.com), I get an error (No Match).

Any suggestion to avoid this issue?


Thanks

Arianna

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!