Hi guys,

I am having again a problem with index(match) formula & iserror(match).

I am trying to write a formula, where bill (column c) would SUM all items (column b), but of course with matching the price list. The problem i am facing here is I can not use "text to column option" and separate items in column b, it must stay as it is. Please see the attached file for better understanding. I would appreciate if you could help me. Thanks.

Book1.xlsx