populating a field from drop down list

[reddcannon]

I am using windows 7, excel 2010 I have a work book, my price list is sheet one and my list of customers and what discounts they get per item in sheet 2.

I choose customer on sheet 1, say i choose a & L sales, well on sheet 2 it shows they get a discount of 45 percent. so I want the 45 percent to show in cell 4r on sheet one, but if the dropdown box shows customer a & V it should show 35 percent because that is what it is on sheet two in cell 3c

Have I confused anyone yet.

Thank you so much in advance,

sheet two has 158 customers and each get a difference discount for that product

 

[T. Valko]

I am using windows 7, excel 2010 I have a work book, my price list is sheet one and my list of customers and what discounts they get per item in sheet 2.

I choose customer on sheet 1, say i choose a & L sales, well on sheet 2 it shows they get a discount of 45 percent. so I want the 45 percent to show in cell 4r on sheet one, but if the dropdown box shows customer a & V it should show 35 percent because that is what it is on sheet two in cell 3c

Have I confused anyone yet.

Thank you so much in advance,

sheet two has 158 customers and each get a difference discount for that product

See if this helps:

http://contextures.com/xlFunctions02.html

 

[reddcannon]

Thank you so very much, it works, I am always amazed at you folks. Have a great day

 

[T. Valko]

Thank you so very much, it works, I am always amazed at you folks. Have a great day

You're welcome. Thanks for the feedback!