HI, I have a product list with different products in each row,
Column A is the number,
Column B is the Description,
Column C is the Quantity,
Column D is a drop down list of options, linked to L8-L13 (list holder
cells) created with the Data Verification function, and M8-M13 is the price
multiplier matched to the option.
I have M5 as the base price holder cell (so I can change the base without
re-wrighting the entire formula)

Column E is the Total for the Row, based on the Option selected from D
Drop-down list linked to L.

I am having trouble creating the formula for "E" for each row based on the
option selected from the drop down.

Thsi is what I am trying to do, (If D5=L8, then M5*C5*M*, or If D5=L9, then
M5*C5*M10) ans so on down the list of options. Each time I try I get a failed
function or a #NAME? error. I have tried SUMIF, SUMIF S