Best way to look up multiple values in a multi-select cell?

I have a schedule that contains tasks, and each task has one or more cost codes associated with it. These cost codes are in Dropdown (multi select) cells. For each cost code in a cell, I would like to look up the associated value and add the values together if there are more than one. I am not sure the best way to do this.

I'll weight the total duration to come up with an approximation later, for now I am just trying to get the corresponding budget numbers to add.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!