For the UNIT QTY column on the LIST worksheet, I am using this formula:

Excel Formula:

`=IFERROR(VLOOKUP(H3,'Cobra-Import'!A:L,5,FALSE),0)`

As of right now, the formula is doing exactly what it's supposed to do, which is pulling in what is in Column E of the Cobra worksheet. Those values are either E, C, or M depending on the item. I need those values to be replaced with:

E: 1

C: 100

M: 1000

Trying to figure out some kind of "If this, then that" type of formula so it assigns the appropriate numerical value.

In another column of the LIST worksheet, I am also using a formula to calculate the material price per unit, which needs the UNIT QTY to be in numerical form unless there is a way to calculate E, C, or M in this column. Here is the formula:

Excel Formula:

`=((J3/K3)+(N3/O3))`

If anyone has any ideas, it will be greatly appreciated!