Multiple selection

Merry Christmas,

Attached is my worksheet. Cell D4 to D8 does not return the right price for the respective material in Column C. I believe this is IF formula with multiple conditions. Appreciate if you could assist amended the formula.

Thank you so much.

EL

Merry Christmas to you also.

You had a condition in your first IF that if the cell in column C was text then return "". This can be removed. You can also simplify the formula by using the VLOOKUP function, so the formula in D4 becomes:

=IF(OR(ISERROR($C4),ISBLANK($C4)),"",VLOOKUP(C4,$I$4:$J$7,2,0))

Copy this down as required.

Hope this helps.

Pete