multiplay sum/vlookup?

Hi, I'm wondering if there is a way to use a sum or vlookup value to what I'd like to do.
I've attached a sample.

I know that sumproduct can be used to return total of multiple lookups in a table. However, my lookup table includes spaces in between the values being looked up, so it messes the formula up.

any help would be hugely appreciated

Thanks