Any assistance that can be offered is greatly appreciated.

In col A I have some codes

aaa

bbb

ccc

ddd etc

I wish to place a formula in col B that will return the cost that applies to the code. The formula will need to match the cost from the row where the code appears but the cost could be in either of 3 colums.

aaa

**£10.00**

bbb £00.00

**£20,00**

ccc £00.00 £00.00

**£30.00**

ddd

**£25.00**£00.00 £00.00

Hopefully I have explained this so you can understand what I need, I can't get HTML Maker to work which would have made it a lot easier to understand.

Many thanks for any help you can provide.