Hi, I've been trying to figure this out for hours but I can't make it work. Any help is greatly appreciated.
I get an output in a cell with multiple values separated by a "+" plus sign. I want to lookup the the strings against a table and come up with a total value. Here is an example:
The output that I get from an export is like Column D. I'd like to be able to look the combination of values up against Columns A and B and return a Sum. So E2 would return 4.
Thanks! File in post below
Bookmarks