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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!