Is there a way to use the solver with the data shown below? I want to have the Solver Table (Columns F-I) pull the data (Columns A-D) with the following constraints. 1) Maximize the sum of the profit (Column H), 2) Keep the sum of the Lbs <= 300 (Column I), 3) Each type must include two different products
<tbody>
</tbody>
A | B | C | D | F | G | H | I | |||||||||
1 | Product | Type | Profit | Lbs | Type | Product | Profit | Lbs | ||||||||
2 | Carrots | Vegetable | 100 | 20 | Fruit | |||||||||||
3 | Apples | Fruit | 80 | 30 | Fruit | |||||||||||
4 | Bananas | Fruit | 65 | 25 | Vegetable | |||||||||||
5 | Pork | Meat | 90 | 50 | Vegetable | |||||||||||
6 | Salmon | Fish | 70 | 35 | Dairy | |||||||||||
7 | Trout | Fish | 80 | 25 | Dairy | |||||||||||
8 | Halibut | Fish | 45 | 30 | Meat | |||||||||||
9 | Oranges | Fruit | 25 | 35 | Meat | |||||||||||
10 | Beans | Vegetable | 25 | 20 | Fish | |||||||||||
11 | Beef | Meat | 80 | 40 | Fish | |||||||||||
12 | Tomato | Vegetable | 40 | 45 | =sum(H2:H11) | =sum(I2:I11) | ||||||||||
13 | Lettuce | Vegetable | 30 | 30 | Maximize | <= 300 | ||||||||||
14 | Grapes | Fruit | 20 | 25 | ||||||||||||
15 | Catfish | Fish | 45 | 35 | ||||||||||||
16 | Chicken | Meat | 75 | 50 | ||||||||||||
17 | Butter | Dairy | 30 | 20 | ||||||||||||
18 | Turkey | Meat | 55 | 45 | ||||||||||||
19 | Cheese | Dairy | 35 | 20 | ||||||||||||
20 | Yogurt | Dairy | 50 | 25 | ||||||||||||
21 | Milk | Dairy | 75 | 60 |
<tbody>
</tbody>