Drop down menu and product - thank you

**Xample** · 04-07-2009, 03:33 PM

your formula looks like what I want but for some reason there is an error...

I attached the file to make sure I did everything right

**DonkeyOte** · 04-07-2009, 03:48 PM

The result I get with

E1: =B1*C1*D1*LOOKUP(A1,{"A","B","C"},{30,10,15})

is 2,700,000

The above is based on UK regional settings - I suspect you may need to alter the delimiters per your own settings (ie use of ; etc...)

**DonkeyOte** · 04-07-2009, 03:53 PM

Disregard that Xample - point holds re: regionals BUT the criteria is now "one" "two" "three" as opposed to "A","B","C" ... Lookup generally requires the values be sorted in Ascending order... in this instance rather than re-order such that they appear out of sequence (eg "one","three","two") I would switch approach from LOOKUP to INDEX/MATCH

=B1*C1*D1*INDEX({30,10,15},MATCH(A1,{"one","two","three"},0))

**Xample** · 04-07-2009, 07:59 PM

still not working

I attached the print screen with the error

Before this there was selected area with error was this one: {30,10,15} but after I went to Tools->Options->International and I unchecked "Use sistem separators"

Now the selected area with an error is the one in the picture