Question: 5. In cell E13, use the VLOOKUP function to return the name of the exact match product name from the Product List table in J5:L38.

 5. In cell E13, use the VLOOKUP function to return the

name of the exact match product name from the Product List table

5. In cell E13, use the VLOOKUP function to return the name of the exact match product name from the Product List table in J5:L38. Copy the formula in E13 into the range E14:E20. (10 points) In cell F13, use the VLOOKUP function to return the price of the exact match product from the Product List table in J5:138. Copythe formula in F13 into the range F14:F20. (10 points) In cell H13, calculate the charge. The charge is the price of the item multiplied bythe number of items ordered. Copythe formula in H13 into the range H14:H20. (10 points) 6. 7. HOME INSERT PAE LAYOLUT FORMLLAS DATA REIEV VIEW AutoSum Calib , Wrap Text Garneral Norma 2 Copy FormatPainter Conditional Formatas Good Formatting- Tabl B 1 u-|;;;. . Merge Center. $. % , Calculation Insert Delete Format Clear liphaard lignmert Oixie Kaufmann Delivery Tyoe urcharge Est. Delivery Days 5 Order Number e Order Date 12.95 1S.S5 S bb11Blister Patche 3b12215 Bot Laces (Medium 14.95 595 .55 2bl6658 Snowboard Leash 3R 75 404 Topeak Lane Fort Smith AK 72314 479| 355-2081 3.70% 11 State 1015 Zendo GPSrmeter ps1587GPS Tra ed?331LED Rechergeable Lantern d991LED Rechargeable t p5148ftng Pad S112.45 395 S21.94 37 25 S 29.1.5 175 22 85 87 178 21 S 234,9 148 21 148 21 S32.55 $48.78 S12.32 394:5 Chargo 13 981 led7991 #N/ A 15 15 Dei Delivery Opdons 7815 3 Day Foam Pad h5SS1 vrb7133 E401 #N/ A #N/A #N/A #N/A pi519 nsulated Jacket Wonen's DwS558 nsulated Pants Women's b2818Down Sleeping Ba 21 b5317 Attack Snowboard Women's b5501 Attack Snowboard Men's b6601 Selar Bat sbB103S Battery Panels b8502Sunblock SPF 30 1Hikirg Sizei g8128Polanzed Snow Goggles h5591 So Helmet Womeri:s sh9810 Sno Helmet Men's p553 Snowshoes Pair Unit hipping & Handing Ehipping & Handling Discount 25 28 29 3 21 t78294 Person Te r 8140 4 Person Tent

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!