|N34||cable mod plate||125||cable||40|
|N35||cable socket mod||connect||10|
|N38||socket connect mod||plate||15|
|N44||cable plate socket||socket||25|
hi i new to advance formulas and i need a formula to look at the code words in the task column
and to sum them as a total from the prices next to the codes in the charge column.
so C2 will look at B2 and check if any words from range E2:E6 appear and add the sum of there corresponding price in range F2:F6 .
many thanks in advance.