Hey Sp00k,
To provide maximum future proofing I would be inclined to do the following
rather than try to put it all in one big IF or CHOOSE combination.
For this example I'll assume the following:
K1 has the drop down list with a selection of A B C D E
L1 has the drop down list with a selection of X Y Z
I would build a hidden result list say columns N and O so your possible
results a
Col N Col O
A-X 10
A-Y 12
A-Z 14 etc etc to cover all combinations
Then the formula in M1 would be:
=vlookup($K$1&"-"&$L$1,$N:$O,2,0)
This joins the results of K1 and L1 together with a seperating dash and then
brings back the value from your results table.
Doing it this way means you can grow your options list without having to
mess with the formula.
HTH
Giz
"Sp00k" wrote:
Hi all,
I'm trying to work out the easiest way for the following:
I have a drop-down list with 5 text values in column K
I have a drop-down list with 3 text values in column L
Based on the comination of the selection in column K and column L I
want Excel to provide a pre-defined value in column L.
Example:
If column K=option1 and column L=optionA then column M should be 20
If column K=option2 and column L=optionA then column M should be 50
If column K=option1 and column L=optionC then column M should be 10
Is there a formula / function that will accomplish this?
Thanks in advance for your help.
Sp00k
--
Sp00k
------------------------------------------------------------------------
Sp00k's Profile: http://www.excelforum.com/member.php...o&userid=33676
View this thread: http://www.excelforum.com/showthread...hreadid=534469