excel formula

  • Thread starter Thread starter Dave O.
  • Start date Start date
D

Dave O.

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
 
=INDEX(F5:O5,,MATCH(A5,{"Mail","Phone","Email","FAX","Courier"},0))*LOOKUP(A5,{"Courier","Email","FAX","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)
 
Back
Top