Match Multi Values to a Table?

amcrandall
edited 01/02/25 in Formulas and Functions

Hello, I am trying to figure out how to VLOOKUP or MATCH or something else to return values from a table. In the example below, in the highlighted row, I would want it to return the three highlighted 'Assigned To' values in the table below. Is this possible? Or is there a better solution that I am not thinking of?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!