Correction to last sentence:
Thsi is what I am trying to do, (If D5=L8, then M5*C5*M8, or If D5=L9, then
M5*C5*M9, or if D5=L10, then M5*C5*M10) and 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

Note Items is L8-L13 are Text descriptions
Items in M8-M13 are a decimal value used as a multiplier eg, 1.2, 1.7, 2.1
etc associated with the option in L.

"RICH1B" wrote:

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