drop down list that changes the data of 3 other cells

[Guest]

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?

 

[Guest]

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.

 

[Debra Dalgleish]

You can create a list with the customer names and their discount
amounts. For example:

Customer Disc1 Disc2 Disc3
ABC Co 5% 10% 12.5%

Then, on in the cells below the customer dropdown list, you can use
VLookup formulas to return the discount amounts. There's a similar
example here, using address information:

http://www.contextures.com/xlOrderForm01.html

See the "Ship to" instructions are at the end

For more information on VLookup, see Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html