the problem is that some cells have more than a character. adicionally some characters should be ignore and not looked up in that table.

i want to to create a formula so that the result, in that cell, is the sum of the lookups.

example:

Code:

```
A VLOOKUP("A";D1:E5;2)
B VLOOKUP("B";D1:E5;2)
AB VLOOKUP("A";D1:E5;2) + VLOOKUP("B";D1:E5;2)
ABC VLOOKUP("A";D1:E5;2) + VLOOKUP("B";D1:E5;2) + VLOOKUP("C";D1:E5;2)
AmB VLOOKUP("B";D1:E5;2) [Am is ignored]
ABmC VLOOKUP("A";D1:E5;2) + VLOOKUP("B";D1:E5;2) [Bm is ignored]
```

thanks in advance