How to use multi-select dropdown list as criteria for sumif/vlookup
Hey guys, thanks in advance for you help.
I have three sheets that I am working with: a database (of sorts), a grid-form summary sheet, and sheet that contains attributed values. To simplify, I will only use a, b, c, and d as production point names and whole percentages as attributed values.
The "database" contains unique project names each with a multi-select dropdown list that have any combination of a, b, c, or d production points. Each of these production points are associated with a certain percentage found in a separate sheet. In the summary sheet (internal, created summary sheet, not Smartsheet's Summary feature) I would like to return the combined value of the attributed percentages based on the multi-select in the database and the similar project names between the database and summary sheet.
I am currently trying to use a mix between a sumif and vlookup and/or a match/collect but I am having trouble getting anywhere. I have attached pictures of the examples.
Attachment 1: "Database"
Attachment 2: Summary sheet with desired result and explanation
Attachment 3: Attributed Values
Help Article Resources
Check out the Formula Handbook template!