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 PriceTable in the Prices worksheet. You
MUST use structured references to the PriceTable 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.
Use The Xlookup Function In The Price Column Of The Orders Worksheet To Return The Price Based On The Product Column In 1 (77.99 KiB) Viewed 29 times
M z N P Q 이 H I j K L Quantity Price Discount % Total Team 1 1 2 8 8 1 2 1 A B С D E F G 1 Order ID Salesperson Order Date Ship To State Name Region Product 2 MG1000 1/1/2021 9-UT-28 Texans Jersey 3 SP1000 1/1/2021 4-WY-85 Buccaneers Jersey 4 SP1001 1/1/2021 2-ID-83 49ers Jersey 5 TJ1000 1/1/2021 2-IL-24 Dolphins Jersey 6 TJ1001 1/1/2021 1-C0-77 Chiefs Jersey 7 TJ1001 1/1/2021 1-C0-77 Broncos Jersey 8 MG1001 1/2/2021 9-TN-76 Panthers Jersey 9 SP1002 1/2/2021 2-KS-90 Broncos Jersey 10 SP1003 1/2/2021 5-MT-60 Packers Jersey 11 TJ1002 1/2/2021 4-ID-45 Packers Jersey 12 MG1002 1/3/2021 1-VA-83 Falcons Jersey 13 SP1004 1/3/2021 9-CA-15 Rams Jersey 14 SP1004 1/3/2021 9-CA-15 Jaguars Jersey 15 SP1004 1/3/2021 9-CA-15 Texans Jersey 16 SP1004 1/3/2021 9-CA-15 Dolphins Jersey 17 SP1004 1/3/2021 9-CA-15 Colts Jersey 3 8 2 7 6 1 2 1 3
С w A B 1 Price Product 2 $ 99.95 49ers Jersey 3 $ 68.97 Bears Jersey 4 $ 90.99 Bengals Jersey 5 $ 98.27 Bills Jersey 6 $ 89.99 Broncos Jersey 7 $ 73.00 Browns Jersey 8 $ 79.99 Buccaneers Jersey 9 $ 75.98 Cardinals Jersey 10 $ 89.25 Chargers Jersey 11 $ 99.95 Chiefs Jersey 12 $ 70.99 Colts Jersey 13 $ 92.49 Cowboys Jersey 14 $ 85.50 Dolphins Jersey 15 $ 76.99 Eagles Jersey 16 $ 85.99 Falcons Jersey 17 $ 77.50 Giants Jersey 18 $ 61.89 Jaguars Jersey 19 $ 82.50 Jets Jersey 20 S 88.88 Lions Jersey 21 $ 80.99 Packers Jersey $ 62.89 Panthers Jersey 23 $ 92.99 Patriots Jersey 24 $ 72.99 Raiders Jersey 25 $ 60.99 Rams Jersey 26 $ 72.47 Ravens Jersey 27 $ 95.99 Saints Jersey 28 $ 75.95 Seahawks Jersey 29 $ 84.95 Steelers Jersey 30 $ 84.52 Texans Jersey 31 $ 64.99 Titans Jersey 32 $ 82.88 Vikings Jersey 33 $ 73.99 Washington Football Team Jersey 22
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!