Sumifs with dynamic criteria from multi-select dropdown

jvalz

I have Sheet 1, having rows where a record can be assigned values from a Multi-Select Dropdown with Requirement IDs (REQ1, REQ2, REQ5).

I have a separate, Sheet 2 with Requirements. Each Requirement has an ID and a Weight.

ID, Weight

REQ 1, 5

REQ2, 5

...

REQ5, 3

I want to assign REQ1, REQ2, REQ5 to a record in Sheet 1 and write a Sumifs formula that returns the total Weight, from Sheet 2 as = 5 + 5 + 3 = 13.

Any tips?