Question: Table 3 A summarizes the prices of eighty three ( 8 3 ) items for sale at a regional grocery store. Alan's Bakery, a local

Table 3A summarizes the prices of eighty three (83) items for sale at a regional grocery store. Alan's Bakery, a local bakery, orders items from the grocery store. In Table 3B, the items ordered by Alan's Bakery and the quantity are summarized. Use the XLOOKUP function and reference the codes in C6:D88 to determine each item's price and the total amount owed by Alan's Bakery.
(1) In cells J6:J19, use an XLOOKUP statement to determine the Price of each item given in column H based on the Grocery Store Pricelist (Table 3A). Specifically, your function should reference values from H6:H19, find them in C6:C88 and return values from D6:D88.
(2) In cells K6:K19, calculate the total owed (price*quantity) for each item given the quantity in column I and the price (column J)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!