Hi All,

In the table below I am trying to makeup a vlookup work with adding all the results in one go, is there a way around it?

Looking at the table below, I would like to lookup each entry in column B and add all the results within columns C:E

so the results would look like

GER = 5
XRAY = 8
CTC = 38
TLS = 50

Untitled.jpg

Thanks for any help