A B C D E F G
1 Amount Item Model Size Supplier
Cost

2


In (A2) I enter # of Items needed
(B2) is a (Validation) Drop down box with a list of Items ranging from 1 to 50
(C2) is a (Validation) Drop down box with a list of Models ranging from 1 to
25
{Each Item comes in at 25 deferent Models}
(D2) is a (Validation) Drop down box with a list of Sizes ranging from 1 to 7
(E2) is a (Validation) Drop down box with a list of Suppliers ranging from 1
to 20
(G2) is the Total Cost for the Item determined by values entered in (B2:E2)
[[Amount (A2)* Cost/per]]
((Cost/per is determined by Model, Size, and Supplier))
To solve for Cost (G2) is fairly easy by the use of formula;
=IF(AND(=" ",=" "), , )
I have a cost sheet for every Item, Model, and Size. By Supplier on a
separate worksheet.
Every thing works great. I get the right amount in (G1) for every scenario.
This would be Great if I need to purchase only (example)
10 of €˜Item 1 €˜Model 16 €˜Size H from €˜Supplier XYZ€�
However I would also need (example);
2 of €˜Item 38 €˜Model 4 €˜Size B from €˜Supplier ABC

So am I right in assuming that I have to have a separate line of every;
Item, Model, Size, and Supplier, like the one above A2:G2 In order to keep
a total Cost of items to be purchased? {[Hmm I dont even want to think about
the number of lines I would need]}
The Value of (G2) will change in relation to ANY change entered (A2:E2)
Or is there a way to Reset the values in (A2:E2) and SAVE the value in (G2)
in order to get a SUM €œCost€� of all Items needed?