Having read your corrections to your original post after I posted a possible
solution, I would say my suggestion will not do what you are asking. Back
to the drawing boards for me with the new and corrected info.

Regards,
Howard

"RICH1B" wrote in message
...
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