Use the XLOOKUP function in the Price column of the Orders worksheet to return the price based on the Product column in the Orders worksheet. Use the Price Table in the Prices worksheet. You MUST use structured references to the Price Table fields in your XLOOKUP function. You may NOT add to, delete, or modify any of the Product data in the Orders worksheet. Additionally, you may NOT add any additional columns to the data.

Please show the formula used for I2!!!!!!

 

Transcribed Image Text:

INSSONORENKF22222222~228528 ssssssssssssssssssssssssssssssssssssss 1 3 4 6 7 9 10 11 12 $ 75.98 Cardinals Jersey $ 89.25 Chargers Jersey $ 99.95 Chiefs Jersey $ 70.99 Colts Jersey $ 92.49 Cowboys Jersey 85.50 Dolphins Jersey 76.99 Eagles Jersey Falcons Jersey $ 85.99 77.50 Giants Jersey 61.89 Jaguars Jersey 82.50 Jets Jersey Lions Jersey 80.99 Packers Jersey 62.89 23 $ 92.99 Panthers Jersey Patriots Jersey Raiders Jersey Rams Jersey 13 14 15 16 17 18 19 21 27 29 $ 99.95 49ers Jersey 30 $ 68.97 Bears Jersey 31 20 $ 88.88 32 $ 90.99 Bengals Jersey $ 98.27 Bills Jersey $ 89.99 Broncos Jersey $ 73.00 Browns Jersey $ 79.99 Buccaneers Jersey $ 33 $ $ $ 24 $ 72.99 60.99 25 $ $ $ 26 $ 72.47 Ravens Jersey $ A Price $ 95.99 Saints Jersey 75.95 Seahawks Jersey 84.95 Steelers Jersey 84.52 Texans Jersey 64.99 Titans Jersey $ 82.88 Vikings Jersey $ 73.99 Washington Football Team Jersey $ B Product $ $ $ C INSSONORENKF22222222~228528 ssssssssssssssssssssssssssssssssssssss 1 3 4 6 7 9 10 11 12 $ 75.98 Cardinals Jersey $ 89.25 Chargers Jersey $ 99.95 Chiefs Jersey $ 70.99 Colts Jersey $ 92.49 Cowboys Jersey 85.50 Dolphins Jersey 76.99 Eagles Jersey Falcons Jersey $ 85.99 77.50 Giants Jersey 61.89 Jaguars Jersey 82.50 Jets Jersey Lions Jersey 80.99 Packers Jersey 62.89 23 $ 92.99 Panthers Jersey Patriots Jersey Raiders Jersey Rams Jersey 13 14 15 16 17 18 19 21 27 29 $ 99.95 49ers Jersey 30 $ 68.97 Bears Jersey 31 20 $ 88.88 32 $ 90.99 Bengals Jersey $ 98.27 Bills Jersey $ 89.99 Broncos Jersey $ 73.00 Browns Jersey $ 79.99 Buccaneers Jersey $ 33 $ $ $ 24 $ 72.99 60.99 25 $ $ $ 26 $ 72.47 Ravens Jersey $ A Price $ 95.99 Saints Jersey 75.95 Seahawks Jersey 84.95 Steelers Jersey 84.52 Texans Jersey 64.99 Titans Jersey $ 82.88 Vikings Jersey $ 73.99 Washington Football Team Jersey $ B Product $ $ $ C

Answer rating: 100% (QA)

To use the XLOOKUP function in cell I2 of the Orders worksheet to return the pri... View the full answer