Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me find the fomula to answer this 9. Next, Felipe wants to find the amount billed for the order entered in cell B5.

please help me find the fomula to answer this image text in transcribed
image text in transcribed
image text in transcribed
9. Next, Felipe wants to find the amount billed for the order entered in cell B5. In cell B7, enter a formula using the VLOOKUP function and structured references to the columns in the Orders table. Look up the value in cell B5, refer to the six columns in the Orders table beginning with Order ID and ending with Total Billed (range B12:G74), and return a value in column 6 that exactly matches the value in cell B5. AutoSave Oft H 8 = LEX19_E. A alyssa locke AL 3 File Home Insert Draw Page Layout Formulas Data Review View Help Pe fr AutoSum Logical @ G B Trace Precedents i F Recently Used Text Insert g Trace Dependents Watch Function Financial Date & Time @ Names FRemove Arrows Window Function Library Formula Auditing X fx =INDEX(Orders[Product Name], MATCH(B5,Orders[Order ID). B6 Kick Scooters April Online Orders Product Categ 4 Order Lookup Table 5 Order ID M 6080 6 Product Name Swerve Scooter 7 Billed Amount Order Informon by Category Category Lumber Sol Revenue Three-wheeler Trick Price Shippin 800 69.00 800 8.00 8.00 8.00 Order DM- 2121 52121 4242021 242121 24 2021 432021 V2021 13/2021 W3 2021 1372021 102021 W122021 4192021 420/2121 W242021 Total Elle 77.00 77.00 77.00 7700 77.00 109 50 Tan 0850 mes 6900 6900 9300 99 m 99.00 99 9900 99.00 99.00 9900 99.00 99.00 9.50 950 950 950 950 950 9.50 Mini Mir Order ID - Catego Product Na MIS M-6333 Three-whee Big 3 Scooter M.5734 Three-whee Ba3 Scooter M-5899 Three-whee Big 3 Scooter K-1442 Three-whee Big 3 Scooter K-7505 Threewee Ba3 Scooter M7005 Mini City Kick Scode M 1779 CityKick Scooter City Kick Scooter M-3313 Mini City Kick Scooter M-7988 CitKick Scoober M-6499 Mini City Kick Scooler M-5443 Citu kick Scooter K-1324 Kick Scooler M-7469 Click Scoala K-6563 Mini Cock Scooter CityKick Scooter M-7080 Mini CityKick Scooter M-5080 Trick Fury Pro Scooter K-5445 Thick Fury Pro Scooter M-5344 Fury Pro Scooter M-7499 Kids GlowScoot M-7953 Kids GlowScool M-1999 Glow Scoot K-5688 GlowScoot M-6734 GoGo Foldable M6222 GoGo Foldable M-105 Mini GoGo Foldable M-6998 GoGo Foldable M5459 Mini GoGo Foldable GoGo Foldable M-1522 Mini GoGo Foldable K-6778 Mini GoGo Foldable M-7779 Mini GoGo Foldable M-1113 Mini GoGo Foldable Documentation 18.50 18.50 MASO 1840 10950 7850 108.50 130.50 130.50 9.50 11.50 1150 118.00 59100 780 7.50 7.50 750 66 50 66 50 5900 4292021 413/2021 4142021 20/2021 2021 41402021 42512121 W212121 492021 422021 4102021 72021 4242021 4242121 4242021 202021 4242021 4212021 200 12900 129.00 12900 200 1200 1200 12.00 14100 1100 14100 1200 1290 12900 129.00 129.00 12.00 12.00 12.00 12.00 14100 14100 14100 April Orders Ready Accessibility: Investigate - 1 fr Insert Function 2. AutoSum Logical Recently Used Text Financial Date & Time Function Library Eg Trace Precedents le Trace Dependents FRemove Arrows Formula Auditing Defined Names - B6 X f x =INDEX(Orders[Product Name),MATCH(B5,Orders 55 50 66 50 7.50 750 750 12.00 12001 12.00 1200 1200 12.00 12.00 12.00 12.00 12.00 66.50 14100 14100 14100 14100 14100 14100 1410 141.00 14100 14100 14100 6125 6125 6125 Kids Kids Kids Mini Mini Mini Mini Mini Mini Mini Mini Mini Mini Mini Kids Kids Kids Kids Kids Micro More Micro Micro Micro Micro Micro Micro Trick Trick Trick Trick Trick Trick Trick PINNNNN 102021 425/2021 420/2021 2021 U13/2021 4102021 415/2021 4242021 4242021 42W2021 0202021 4242021 42712021 0292021 41712021 420/2021 420/2021 2242021 4282021 402021 418/2021 2021 4/19/2021 420/2021 4242021 4242021 428/2021 452021 4/10/2021 4192021 4202021 425 2021 4272021 4292021 452021 4712021 4142021 420/2021 4242021 4242021 425/2021 430/2021 6125 6125 M-7553 M-1988 K-5689 M-6734 M-6332 M-1005 M-6999 M-5469 K-5664 M-1322 K-6778 M-7779 M-1119 M-7778 K-6005 M-5005 K-6469 K-7665 K-4444 M-1688 M-5804 M-1469 M-7355 M-6669 M-3443 M-3334 M-6080 M-6688 M-5778 M-1552 M-6305 M-1734 M-5254 K6604 M-7734 M-5499 M-5559 K-7804 M-5405 M-2105 M-7688 M-8011 D GlowScoot GlowScoot GlowScoot GoGo Foldable GoGo Foldable GoGo Foldable GoGo Faldeble GoGo Foldable GoGo Foldable GoGo Foldable GoGo Foldable GoGo Foldable GoGo Foldable GoGo Foldable Higgle Kids Sco Higgle Kids Sco Higgle Kids Sco Higgle Kids Sco: Higgle Kids Sco Swerve Scooter Swerve Scooter Swerve Scooter Swerve Scooter Swerve Scooter Swerve Scooter Swerve Scooter Swerve Scooter Trickx Scooter Trickx Scooter Trickx Scooter Trickx Scooter Trickx Scooter Trickx Scooter Trickx Scooler Zip Lux Scooter Zip Lux Scooter Zip Lux Scooter Zip Luc Scooter Zip Lux Scooter Zip Lux Scooter Zip Lux Scooter Zip Lux Scooter E 59.00 59,00 59 00 12900 129.00 129.00 129.00 129.00 129.00 129.00 12900 129.00 12900 129.00 5400 5400 5400 54.00 5 4.00 89.00 89.00 89.00 9900 89.00 89 00 89.00 89.00 129.00 129.00 129.00 129.00 129.00 129.00 129.00 79.00 79.00 79.00 79.00 79.00 7900 7900 79 00 96.22 o o o o o o o po DDDDDDDDDDD 88888889 BROCEDECESS 12.25 12 25 12.25 1225 8.49 8.50 72 Micro 849 Micro Micro Micro Micro Micro Micro Micro 14125 14125 14125 14125 87.49 8750 87.49 87.49 87.49 87 49 87 49 87.49 6676.43 8.49 849 78 April Orders Documentation CX Accessibility: Investigate Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions