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 A summarizes the prices of eighty three items for sale at a regional grocery store. Alan's Bakery, a local bakery, orders items from the grocery store. In Table B the items ordered by Alan's Bakery and the quantity are summarized. Use the XLOOKUP function and reference the codes in C:D to determine each item's price and the total amount owed by Alan's Bakery.
In cells J:J use an XLOOKUP statement to determine the Price of each item given in column H based on the Grocery Store Pricelist Table A Specifically, your function should reference values from H:H find them in C:C and return values from D:D
In cells K:K calculate the total owed pricequantity 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
