Every time I think I have ........I DON'T!!!
Example;
Lets say I have 2 Drop-Down Boxes D1 D2
D1 has Product listed. (Example; Apples, Pears, Peachs, Duck Soup€¦..)
D2 has suppliers listed. (Example; Orchard A, B, C, Dicks, Janes, Spots)
D3 is where I enter the amount of product I need (1lbs 2lbs 5gals ...)
G2 is "Total" amount "$1.00's "for all Apples, Pears, Peachs, Duck Soup
that I need to purchase from all suppliers.
I have a price list of each, Orchard A (R10:R16), B (T10:T16), and so on
So lets say Duck Soup at Janes cost $1.00 a Gallon, and I need 10 Gallons
D3=10
Z10 = $1:00 (Jane's pric list Z10:Z16)
Y3 =IF(AND(D1="Duck Soup",D2="Jane's"),Z10,0)
So in this case G2=Y3*D3 (G2=$10.00)
What I would like to do is keep a running Total for every thing I need to
purchase in G2. Since D1 and D2 change for every product and supplier
Can this be done with the changing variables that I have?
Or do I have to have a separate Data entry line for every product and
supplier?
I have over 50 products and 20 suppliers€¦.PLEASE HELP
Aspirin, Tylenol, and Advil running low!!!!
Thank You