(Solved) : Felipe Created Lookup Area Range A4 B7 First Wants Find Product Name Associated Order Id E Q43992371 . . .
please help me figure out the formula to answer thisquestion
Felipe has created a lookup area in the range A4:B7. First, he wants to find the product name associated with the Order ID entered in cell B5. In cell B6, enter a formula using the INDEX and MATCH functions and structured references to the columns in the Orders table. Return a value from the Product Name column that exactly matches the value in cell B5, which is listed in the Order ID column of the Orders table. 8. alyssa locke AL ILLEX19 E. AutoSave Power Pivot View Help Review Formulas Data Page Layout File Insert Draw Home κ ΣAtoSum E Recently Used E, Trace Precedents 2 Logical e Trace Dependents Remove Arrows A Text v Calcu Optie Watch Defined Insert Window Names Date & Time Financial Function Cll Formula Auditing Function Library B6 D. B. CITY IPORTI Kick Scooters April Online Orders Product Categorie Order Information by Category Category Order Lookup Table M-608o 4. 5 Order ID 6 Product Name 7 Billed Amount Мcго Number Solc Revenue Mini Mini Kids Three-wheeler Trick 10 Categor Product Nam Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Fury Pro Scooter Fury Pro Scooter Fury Pro Scooter Shipping Total Billed Price Order Date 4/3/2021 4/s/2021 4/24/2021 4/24/2021 4/24/2021 4a/2021 4hl2021 4/13/2021 4/13/2021 4/13/2021 4/14/2021 4/17/2021 4/18/2021 4/20/2021 4/24/2021 4/24/2021 4/28/2021 4/13/2021 4/14/2021 4/20/2021 4/5/2021 4/14/2021 4/25/2021 4/27/2021 4/s/2021 4/12/2021 Order ID 69 00 69.00 69.00 8.00 77 00 M-6333 M-5734 M-5998 12 8.00 77 00 13 8.00 77 00 14 69 00 69 00 99 00 8.00 77 00 K-1442 K-7505 15 8.00 7.00 108 50 108. 50 108.50 16 M-7005 M-1778 M-4344 M-3313 M-7998 M-6499 M-5443 K-1324 M-7469 K-6663 M-Bos1 9.50 Mini 17 18 9.50 9 50 9.50 9 50 9.50 950 9 50 9 50 9.50 Mini 99 00 Mini 99 00 19 99 00 Mini 20 21 22 23 24 25 Mini 99 00 108. 50 108 50 108 50 1ట కి 108 50 s08. 50 99 00 99 00 99 00 99 00 99 00 99 00 99 00 119 00 Mini Mini Mini Mini 26 Mini Mini 9.50 27 M-708o M-5o8o K-5445 M-5344 M-7499 M-7553 M-1998 K-5688 M-6734 M-6332 Documentation 9.50 11 50 11. 50 11 50 28 Mini 130.50 130 50 Trick 29 Trick 119 00 30 130.50 Trick 119 00 59 00 31 66.50 7.50 Kids GlowScoot 32 66. 50 66 50 66.50 Kids GlowScoot 7.50 59 00 33 59 00 59 00 129 00 129 00 Kids GlowScoot 7.50 34 Kids GlowScoot 750 35 26 GoGo Foldable GoGo Foldable 12.00 141.00 Mini 12.00 141.00 Mini 37 April Orders Ready Accessibility: Investigate Show transcribed image text Felipe has created a lookup area in the range A4:B7. First, he wants to find the product name associated with the Order ID entered in cell B5. In cell B6, enter a formula using the INDEX and MATCH functions and structured references to the columns in the Orders table. Return a value from the Product Name column that exactly matches the value in cell B5, which is listed in the Order ID column of the Orders table. 8.
alyssa locke AL ILLEX19 E. AutoSave Power Pivot View Help Review Formulas Data Page Layout File Insert Draw Home κ ΣAtoSum E Recently Used E, Trace Precedents 2 Logical e Trace Dependents Remove Arrows A Text v Calcu Optie Watch Defined Insert Window Names Date & Time Financial Function Cll Formula Auditing Function Library B6 D. B. CITY IPORTI Kick Scooters April Online Orders Product Categorie Order Information by Category Category Order Lookup Table M-608o 4. 5 Order ID 6 Product Name 7 Billed Amount Мcго Number Solc Revenue Mini Mini Kids Three-wheeler Trick 10 Categor Product Nam Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Three-wheele Big 3 Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Citykick Scooter Fury Pro Scooter Fury Pro Scooter Fury Pro Scooter Shipping Total Billed Price Order Date 4/3/2021 4/s/2021 4/24/2021 4/24/2021 4/24/2021 4a/2021 4hl2021 4/13/2021 4/13/2021 4/13/2021 4/14/2021 4/17/2021 4/18/2021 4/20/2021 4/24/2021 4/24/2021 4/28/2021 4/13/2021 4/14/2021 4/20/2021 4/5/2021 4/14/2021 4/25/2021 4/27/2021 4/s/2021 4/12/2021 Order ID 69 00 69.00 69.00 8.00 77 00 M-6333 M-5734 M-5998 12 8.00 77 00 13 8.00 77 00 14 69 00 69 00 99 00 8.00 77 00 K-1442 K-7505 15 8.00 7.00 108 50 108. 50 108.50 16 M-7005 M-1778 M-4344 M-3313 M-7998 M-6499 M-5443 K-1324 M-7469 K-6663 M-Bos1 9.50 Mini 17 18 9.50 9 50 9.50 9 50 9.50 950 9 50 9 50 9.50 Mini 99 00 Mini 99 00 19 99 00 Mini 20 21 22 23 24 25 Mini 99 00 108. 50 108 50 108 50 1ట కి 108 50 s08. 50 99 00 99 00 99 00 99 00 99 00 99 00 99 00 119 00 Mini Mini Mini Mini 26 Mini Mini 9.50 27 M-708o M-5o8o K-5445 M-5344 M-7499 M-7553 M-1998 K-5688 M-6734 M-6332 Documentation 9.50 11 50 11. 50 11 50 28 Mini 130.50 130 50 Trick 29 Trick 119 00 30 130.50 Trick 119 00 59 00 31 66.50 7.50 Kids GlowScoot 32 66. 50 66 50 66.50 Kids GlowScoot 7.50 59 00 33 59 00 59 00 129 00 129 00 Kids GlowScoot 7.50 34 Kids GlowScoot 750 35 26 GoGo Foldable GoGo Foldable 12.00 141.00 Mini 12.00 141.00 Mini 37 April Orders Ready Accessibility: Investigate
Expert Answer
Answer to Felipe has created a lookup area in the range A4:B7. First, he wants to find the product name associated with the Order …
OR