1 | Database_arr | |||||
---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Calories | |
3 | 1 | Caprese Salad | Vegetarian | 5 | 200 | |
4 | 2 | Burrito Eroica | Epicurean | 10 | 1900 | |
5 | 3 | Celery Rawshticks | Vegan | 3 | 100 | |
6 | 4 | Linguine al Pesto | Vegetarian | 15 | 400 | |
7 | 5 | Swiss-Mushroom Burger | Epicurean | 14 | 700 | |
8 | 6 | Nutella Sandwich | Vegetarian | 3 | 440 | |
9 | 7 | Paella Valenciana | Epicurean | 40 | 650 | |
10 | 8 | Risotto Milanese | Vegetarian | 30 | 600 | |
11 | ||||||
12 | ||||||
13 | Criteria_arr | |||||
14 | Key | Recipe | Category | Preparation | Calories | |
15 | 8 | >25 | ||||
16 | ||||||
17 | Result | Formula | ||||
18 | Risotto Milanese | =DGET($A$2:$E$10, "Recipe",$A$14:$E$15) | ||||
19 | Risotto Milanese | =DGET($A$2:$E$10,B2,$A$14:$E$15) | ||||
20 | Risotto Milanese | =DGET($A$2:$E$10,2,$A$14:$E$15) | ||||
21 | Risotto Milanese | =DGET('General Usage'!$A$2:$E$10,2,$A$14:$E$15) | ||||
22 | ||||||
23 | ||||||
24 | Criteria_arr | |||||
25 | Key | Recipe | Category | Preparation | Calories | |
26 | Vegan | 3 | ||||
27 | ||||||
28 | Result | Formula | ||||
29 | 3 | =DGET($A$2:$E$10, "Key",$A$25:$E$26) | ||||
30 | 3 | =DGET($A$2:$E$10,A2,$A$25:$E$26) | ||||
31 | 3 | =DGET($A$2:$E$10,1,$A$25:$E$26) | ||||
32 | 3 | =DGET('General Usage'!$A$2:$E$10, "Key",$A$25:$E$26) | ||||
33 |
1 | Criteria_arr | ||||||
---|---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Preparation | Calories | |
3 | >=7 | >25 | <=35 | ||||
4 | |||||||
5 | |||||||
6 | Average Calories | Formula | |||||
7 | 8 | =DGET('General Usage'!$A$2:$E$10, "Key",A2:F3) | |||||
8 |