Is there a way to put multiple vlookup lookup values in one cell and have the result of multiple vlookups appear in one cell? For instance, I have this table:

Code Amount
A 5
B 6
C 8
D 9

I have a cell that contains "A, B, C"

I want the vlookup to reference the cell that says "A, B, C" and return the sum of the values for A, B, & C, in this case, 19.

I previously did multiple vlookups in one cell with a + operator between them, and had A, B, and C each in a separate cell.

Is there any way to put multiple values in one cell and have the vlookup sum them automatically? They don't have to be comma separated, if that makes a difference. But they will be varying groups of text with a varying number of characters.