reddcannon
Board Regular
- Joined
- Aug 11, 2011
- Messages
- 110
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
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