Thanks I corrected the last sentence in the 2nd post. or here for easier
reading.

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-writing 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.

This 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 e.g., 1.2, 1.7, 2.1
etc associated with the option in L.






"L. Howard Kittle" wrote:

I'm unclear if you stated your case correctly...?

<If D5=L8, then M5*C5*M*,

M5*C5*M???*???

<or If D5=L9, then M5*C5*M10)

and here do you mean M5*C5*M9 instead of *M10?

Taking a semi wild guess try this in E2 and pull down:

=$M$5*C2*M8

Where your headers are in row 1 and data is in A2 to D6.

HTH
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


.