Index Match Function with Multi Select Dropdown

ssuddendorf ✭✭
edited 09/26/22 in Formulas and Functions


I'm looking to create a formula that will look at a multi select dropdown and use that to match to a reference table on another sheet and give back a value for each item selected.

This is a copy of the reference table I'm using.

My desired result is below.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!