Parse multi-selection cells

Andrew Davidson

I've poured over several threads about JOIN() formulas, attempting to parse values from a multi-selection cell [Supply SKU]. The end goal is to use those values to lookup another sheet to bring in a cost. The A,B,C formulas in this thread are the first to get the result I'm looking for however, I have up to 14 values that could be selected. Here are some examples of what I'm working with. Since I have so many values that could be returned, I feel I need to go back to the JOIN() (maybe JOIN(COLLECT())?) formula but can't seem to get it working past the 2nd value. I added in a delimiter "+" to see if that would help but to no avail. Any thoughts are greatly appreciated!

Leibel S

@Andrew Davidson

Do you want to bring in the total cost for all the items together?

An example of this would be:

=SUMIFS({Range of Product Costs}, {Range of Product Names}, HAS([Supply SKU]@row, @cell))

Leibel S

@Andrew Davidson

Do you want to bring in the total cost for all the items together?

An example of this would be:

=SUMIFS({Range of Product Costs}, {Range of Product Names}, HAS([Supply SKU]@row, @cell))

Andrew Davidson

@Leibel S thank you very much. That appears to have done the job!