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
Check out the Formula Handbook template!