excel formula
 

I have a drop down list with at least 8 different values. ie. Training,
Mail, Phone calls etc. in A5. The commissions vary based on the service. I
would like to have a different commission formula for each one. As an
example if they sold mail the formula would be (F5*.1), if they sold training
it would be (G5*.2) and so on. How do I reference these different formuals
to the different selections in A5? Thanks for your help.
Dave

excel formula
 

=INDEX(F5:O5,,MATCH(A5,{"Mail","Phone","Email","FA X","Courier"},0))*LOOKUP(A5,{"Courier","Email","FA X","Mail","Phone"},{0.1,0.2,0.3,0.35,0.5})

The match list can be any order, LOOKUP needs the list in sequence.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dave O." wrote in message
...
I have a drop down list with at least 8 different values. ie. Training,
Mail, Phone calls etc. in A5. The commissions vary based on the service.
I
would like to have a different commission formula for each one. As an
example if they sold mail the formula would be (F5*.1), if they sold
training
it would be (G5*.2) and so on. How do I reference these different
formuals
to the different selections in A5? Thanks for your help.
Dave