It sounds like an issue where VLOOKUP can be used (to see how to use VLOOKUP
go to http://www.auditexcel.co.za/lookupandreference.html ). Have 3 vlookup
cells that make reference to the drop down customer name and pull through the
relevant discounts. If I have misunderstood please rephrase your question.

"Mark R Burgess" wrote:

I select a customer from a drop down list and on selection I need 3 discounts
to be input into the three cells below. These vary from customer to customer
any ideas how I can do This?