1. What did you accomplish by using the XLookUp function?

2. As a manager of City Market, how would you use the outcome of this worksheet to better manage the business?

3. If you were to add a criteria range or filtering technique to the worksheet, what kinds of data and conditions would you search for? Why? What criteria would be most important to the owner of the City Market?

Transcribed Image Text:

City Market Product ID Produce Stock Date Sell By Date Shelf Life 471829 Fruit Apples 9/5/17 9/24/17 19 Days Left 15 A Grade 716281 Fruit Grapes 9/3/17 9/13/17 10 4 D 895241 Fruit Oranges 9/9/17 9/19/17 10 10 B 987456 Fruit Peaches 9/4/17 9/14/17 10 5 D 821928 Fruit Bananas 9/9/17 9/16/17 7 7 C Days Left OF 3 D 7 C 9 B 14 A Grade Table Grade 835570 Fruit Strawberries 9/5/17 9/10/17 5 1F 369718 Vegetable Potatoes 9/8/17 9/26/17 18 17 A 558129 Vegetable Carrots 9/5/17 9/19/17 14 10 B Output Area Table 638192 Vegetable Lettuce 9/6/17 9/19/17 13 10 B Grade A count 2 721890 Vegetable Tomatoes 9/9/17 9/10/17 1 1F Grade B count 3 526891 Vegetable Green Beans 9/4/17 9/14/17 10 5 D Grade C count 2 557812 Vegetable Mushrooms 9/7/17 9/17/17 10 8 C Vegetable count 7 491526 Vegetable Onions 9/3/17 9/10/17 7 1F Fruit Count 6 Current Date ==> 9/9/17 City Market Product ID Produce Stock Date Sell By Date Shelf Life 471829 Fruit Apples 9/5/17 9/24/17 19 Days Left 15 A Grade 716281 Fruit Grapes 9/3/17 9/13/17 10 4 D 895241 Fruit Oranges 9/9/17 9/19/17 10 10 B 987456 Fruit Peaches 9/4/17 9/14/17 10 5 D 821928 Fruit Bananas 9/9/17 9/16/17 7 7 C Days Left OF 3 D 7 C 9 B 14 A Grade Table Grade 835570 Fruit Strawberries 9/5/17 9/10/17 5 1F 369718 Vegetable Potatoes 9/8/17 9/26/17 18 17 A 558129 Vegetable Carrots 9/5/17 9/19/17 14 10 B Output Area Table 638192 Vegetable Lettuce 9/6/17 9/19/17 13 10 B Grade A count 2 721890 Vegetable Tomatoes 9/9/17 9/10/17 1 1F Grade B count 3 526891 Vegetable Green Beans 9/4/17 9/14/17 10 5 D Grade C count 2 557812 Vegetable Mushrooms 9/7/17 9/17/17 10 8 C Vegetable count 7 491526 Vegetable Onions 9/3/17 9/10/17 7 1F Fruit Count 6 Current Date ==> 9/9/17