2 Using the dataset in the sales worksheet, write a formula (in a separate worksheet) using the MATCH and OFFSET functions to display (based on a store location and product which the user of your worksheet chooses) the sales. For example, if the user chooses the store location, London, ON and the product, Laptop, the formula result 31P I should display $668,703.31. If no data is selected, the result should not display #N/A. GAD Det Het 10 Se 16 IS TO OVERS SME LES BAS Alat 9410 US 512M 116 SA EM HALA $1.29 $200,00 $1701310 SA BAR HEON SIM THIS De ASS 52000 SOM 10m 517 ST $0,16 SMOS $12. 317 SOCAR Carrying 11.11 $10 SEA $320 53000 SA 44 54611 Saw $1,117 71 50170 Sca SU SURE 11 10120 MAS 14 $513.4 Spin 19 28 SSS SLANG 05 BAGS Sus EL ME H Mard View LON 7756 S6 1991 444 12 123 S420 SAMO $ 90 SAM UT 11.09 13452 5144 . NG SH $44 SEAT F SI $IMAGEN SIA $1,19 $117.20 1941 SUM SHO SALAT HAL BAN 5:23M SHO 50 OVE 23 SA 1000 544395 SAMAS 016 $224331 52.7 os $1040170 $100 SAS 541272 $19.9 $132.706.78 SO 31 SAS SA SAL 9441 $11.40 54 STEN 14 WY MOM CK $92 S. ROLL 15 143 ST PG 124) HOLA 5614 SUN 16 3440 ET SI Tone $119,147 SUS $1,103 $100187.50 SUN 14 ANA $146147 SUR0.00 30 $21.999.04 $ SINH S33 SUS4,20 10 SULLTYD $1,62 ste SALON SIMIN SLR FU 14.40 SUMM 18. SP 16 SHA S. 543 20 MENU 130 SW41 6.4 $19.95 SAP00 19.30 TO $1,100 $11011 51827220 SUM 2015 SMO w OS IT 10 SON SIS $10 51713 SUN w IPIN S. 10 MIT 14 NA ME $180 SUMUS Warn M 514631 LRT 22 1991 $. 11547 SM 92,00 IN S1414 201410 SAM $111 SIS $14.99 $123 SER SIA 411 $1973) ST S 511,000 SM) 54 $71, FITN SH MATT JU 163411 SA SIN $56 36 SA S. 25 HAL $1114 12 0,36 SOS WA 14 LET 5700 SILA $16 5217 STAT 110. SU 51014 SLIME 51 SIST He IN M BE 319.374 SUS 4 EN SU STESSA SIMU SLAN SH bre RIB 22 SA A14 $382. SME $1911 US SA SHIR SAZURI $426 SO FTTH w th SA PAL 28 52 11 SI 3,000 $1471 5 SON 5204120 M 5110 SINAN curs 5048 SU SMED 143 MUNGU MOND 113 SEM SAMA 90317 30 5429 MA AN 46 34 MONT PIRMO $2117 P10 400V 10 SING DOT SS SES S431 V M BON M SHOLALI S. SAMMLY FIT 111 SIS 15006 5012 GAR SIS SH TITRES FE2U GARAN SURES SPUITM 1113 1 Www 18 12 MT41 ES SU SIA SIS LIE MAR w 12. SU SUS 1970 54 S431 1,500 . www WO MON SATTA $119 111 $180 SE25 TADO BURN Baru CAN STELLO AN SOS 19 16 THE HTU 116 SLATE SLAST SEAL $ SN SLO UNA 13940 US pe UM 11 SADA 59, SA 1 SIAM LES SALMO 1 114 50 40, SIMS SO 19.34 141 MAIS 323 BIR SME SHA LEBO US COS 141 . STS ST 141 $ SMS SHARE $415 1 SINO SAL FUN11 23 MUNCES WW % 119 10 S AR 1, 54 SA 13 SLAN S 11 SO 05 S SAS SEP 214 460 SA 00 SANT HOM SIST SARA SIUNI SA WORD 2000 SIL SM SIE SON S STRO SA BUS w SHARM SUB HA SAT Se M $19.00 DI www 101 2015 NAT SILLA OS Hur 54 WA SA SLANG SIS RSS 11025 BU 03 TH $1141 SANT 33318 SITIS 1060 5 HAN SALON SUMMER St Ghi PAROLI $32,34 MA SA 11 19 1911 HOS CE SM 13 SUM SMS US 50041 17. MO SWSP $34348 S. SIST SUM Semu SUNDI S40 HUU WAS M SPA SM 06 MS R1 16134 2013 SA 107 SH SH SU 1920 NA HS ZA 11 10 NA $4,5 1932 1 MN SARAM WY Det OVO $12,00 14 $44 EVEN 454 HA LE NEWS EN SH SALI M TI SA 14 NA S. HT WAN D $14 18 AN 16 SAL SOS 24 700 EDC DO SA ME w VI LOS 14211 SES PU SUTI TUM M 3 08 514 40 15 SA S4 5384 1334 12 SRL SUU PAD WI HUIS CES SI A10 3134 F SAM 134 140 w EM SUN w w ws 57,1 15:46 1141 525200473 SSMO 11 Torrut ws RULES MENS HI 20 NONS SVS ten Bay Port LOC HT VON www We Gurbet Oy C New 20 544509 3125 32725251 33257 5464110 SAH SIL 1994 59,02141 41. 111 111025 $13 11145211 SUM SH SOPAS SIGLATS SIAMO 141, SOUTH $3124126 11222041 WT WSW RECE $13040 55.947 55931 $1111 SM41 S01 35 SED. 17 3 51,528.12 $53 $9513 SIAS M 2972 CERT 5938.4 37.31 57142123 31165400 136 Wars NE NEWS LEOSTS co 7 2 22 78 HUS AVIS 01 W 5964 SAN SAM 54,141 27 SINH 545015 35111 3401 50 BAL SIS S. SAT.15 5,119 SEO 5901681 $12.12 Som 50055 332ML SAMLI SA1111 5. 429593:59 123597 SIMAS SANT SM $14 SNN ITOS OSTS SSS TES 78 SAB LO WS WICHT Det Lang Man VAN 5148 320 12 51431 SUI 15 AN SIMO 520 SON 39 3117 . 19 1234 513440 512101 SE! SA 55 $ SA N1 SA HO MES OTS S4 De 58113 Star TAN SS LES 2 MO 3310 31 12.30 3141 $4562 517331 SOS Low MOLTS SU 10 3 SUSH SI 590031 SALT 53 3215377 5651 5 52100 557 350.00 S2) 5991.AT 521) SARY 14.SOR SOU SIMI 329,450 $588,39.00 3. 02 00 SS33 $493,13473 52774 549443 $19.11. 543234 SA $13443115 $19.95 180357.44 309.07 11411413 S0914 STAN 4 25,00 51 SINH 521541) 164 SOMM 59903 5. 37273 51234 5237 5140 SM SA 550 SOM SHOME $150 3567.7101 344100 3514 19.95 3304 $4,2012 SSS SOS 3199.00 ww2 51715 S. $200 WAL 110 32 51 SANIN 500 ts 110 52 SOS MA S1 23 1740 HINT 5.4 500 SAMAS 104 SSL 5715 1. SAUS 2. SHIN S2 ASI ve Port Moody SWS TH - 36.266 SCM 041 SO 599 SALAN 3 1 LOW SUIT TE NEWS torte NS Ford >> 1921) SMS Sun 922149 104 SM 21 TES WTS WIS 54,3334 23 584131 SUM $2121 SHOLAWAN S. 144 Sen 2 $UNIAN SAMS4 SAMOLOT $120072920 51944 SUM $5303 U16 55520 $40 SA 515170 Sao 91 35144 51511122265 SUN 2061 . 31,32891 56 $11 55.2010) $1,77305 SAVAS 511407 54931 2584481 us on 54 3221 30 SEO $1.09. 368233.00 $1.31937.90 5108240 31495040 16 302.13 174 $22.03 $5.500 SILO SE442 $175,0810 HAR SATA SUS SHAR 23 $ 2.50 41,01 SAS SO 11 $ 219 $300 51,370,95741 S. SAN SSAN13 51. 5011 5726980 3130 SY SUAL ST 22.11.2011 56 1410 SALA 114 SLIM HUIS 32.15 SUS SUM 4 SATAN ATM 15 51684 SMUL SALON 54500 SOM SUN 1410 $19,90 564 LL SMU. HAM SCOLI 30 $40 NOUS 32873 SE34671 31394 5144173 SIS 513042118 1.4. $1111 SAISON 5223 SADE NARR SA 4 221 SI SLUR SHA25 SI 720 MUTL01 SUM STAM 51.440 5493584 51,23,3256 3470 SI SIM 525 SESES, SP 11 SL15 SM 554449 5901291 37,20 55410 35USES JUICIO 5218 SU 54441 SUPO SB 8.31 11.12.2004 SU SUS 18 5919 S. SIS 39 $137. 1.04 SUM 14 SUM 1024 SAT SLS US SOM 2 S408 2497 14 5430 2 32,272.722.02 5555 SM $12,2251 SLIM 311 2011 5149 14 SU SU SIM SA SEAT 14 SALIM SA 11 5 SIS SUB SL Sans HO SNR 31 SL SOROS 30 14 1441 S1 ES TIVOS LES sus SIIS 545102 1944 AT NE Hur ICO ws SHA 2014 5923 SM SI HOREN TATTI 1 14.00 100 10 101 an 104 06 10 ar 100 1 20 44121 $170, 5520631 270041 21135 $1477 SUSAT 01 SIS 14 SMUM 51 SIGN SA $7310 9345 SMO SP SA 21 M 54 510 9. 91 MAS 101 17 SU SCH 32922950 5 5TH 31000 3 AT 5140 37.5 S. EISEN TA 5480 SH 350 2003 $225,00 4262 SI $123 5915 SUM S. SA 37NNI MA w $9.5031 STAT SA S2325 SH 14 SU 54 SHO $105 . SITA 5102 BUS SAMI 542 401 SIS S11 141995 $12660 NO SLIM $422. 1 521 501 SS SHITA SARM WO 51 SH 2016 YLUS 516 M SIIN SI A. SI SA SI SIM 10 STNM 10232 SANAT 24 2703159 SU 22 SA RIT 31 MO 10 22:20 540 94 SINU ST 14 SIDE SUARZO SANT 51 SAM $7.95 SA 11405 WS NOW VONS SU 1190 SL SA SA 52 AUST 011 S MDC WEN SAN SOM 526272 5170 SAM 143 HU IN 16 SK WS SAN 23 5170 SA 53001 2.52 57 SMANN SIM SAL M SAN 225 2016 32052 11 514 SM AD 55170 SAMM 5452 SUN 111 2.367 SANO 34 S TO BKS SIT SAN NU AN MOTOS TAS w NA PENY SURU SOM SV NS www now 10 IS 1 54,00 RA Am w MOHAS TES SIN SUMIT SU 100 M CHE 31 DU SEM SANTE LA SA SAT USA 24 SUS AM SL SEL SU SO s US WS SOS UN SMA 14 int LE IRON 32.91 3 MW Tu ONS ES MOS 51752 13 SAMI FC MATES SM MIT D 1 M 0 New ON 1 3154 5344 12.7 SPRE sut 15 W CHECY WS WOES WS 1940 M 52 SIL SIR 3 11011 SOR 11 DI SA SE 513114 SP 30 SHARE SHA 3054 SIS 1113200 11241 541,1010 $17 SURASS 305 sum. 01.10 SS15 S40 SA 361541 5411 SM S.SE OXU $3AM 31710 M2 SEM 5774 AL 339.722 27 NEW Os The We 33.561 SA 504355 $111.08 21 $11131 S. SAMO 577204 1110 SA 13 MUM 15 SEMIN Hur re 46 The SA SOAT SL SL71 SALO STAMMY SLIDE $1,224475 $1,222073410 5121009 STOSOP SES 51.JM BAS SUM SOLAR . $ 12.40 AN 100 S1467,20 179 TES $71934 He was TOT 52.209.22 517145 SANI SU . SI $12.00 $ SI 14 $100 51234 1 1410 . 51210 5.2013 SI SAMSU AND CO ON LOC MUM SHI, SAS 14.40 ti 1953 110,000 1934 SET $28.909 SEN S54 SALAS 5. 9811 NE ON INTER 10 ASANT STAR SANT SIP 14 $ $13.5.10 E. HUS SAT SA $1752.00 1120 5.06. HOS une SMUL 4111 10 SES 5121 51,023 AM SM 00 AM 14 1464 BSP 39 WA $16 18 14. SUM SESILA FI WS SO LA , MART SA $27,3301 HIS TELES GOSTS THESE TI SMP SALE $14. $ S1 $11311 $14 SALDI IBAN SI SAU SOAS LAST 34 SALAM 2122 3210 4 12053 SANTE TEC 11511 A ca OM SAP04 JUS 596 WOW 17 $15 ST 1 $1114 JIM 1 SIS AND AM YOU 17, 2.00 MOS $43.341 5.34 WU MMMM $101 SI 11 S. $2001 S. $14,1 BAR ST SPOR KITA 3,44 54627.00 $14 5571 $ 555 SUN SU $1.5 HASAN SALAM SALON $2. HA HT ME 141 3 19 HUTAN SA SUMEN 19 $ Sewed WE VERS SE NE SAS ALT SA S433 10 TEIS 9 ETI SA BAN S4020 SH 328 3499 1914 4 OOC 15 i vores LAS Ti| PE 530 14 52 5233 1 43 ME SPUH SIL 1, R WE WSS $13 3.0 WAST SP S4 Se 1 3 1914 SABT4 MAN SEN . SHA SER ANO 11 SMS 5367 557310 . SM 32,113 SA 5452 SUM SU 31 AM 18 MO SUS HIN AM MUN 5 S1 114 41 AM SP $1 WU www. 5118 SMAR IMA SON SEMUA 5400 20 14.12 34 W IN 16 HIM NIE S431 544 AM 33 BATAN M SUB $27,135 TUNAS 554100 . SALE SA SHINI MS TE I WOTE ww 14 5. SES SA 14,5 1111 BU 14,17 ST 10 $2241 sem SAS WA SINI 1 SI DEWI 1 SW M BUS SH SA SA FM SILI w BOUT S M CE Owen VES SM SHARE SIM BM SATIE SUBS SUU SUM SNAV11 SON M HU HOV MIR SHO 16 VITTOR UM PVN ir MAR BN SAN 23 11 JUU BLIR NO SIA SHARE M SUR HAN HO SALATI SMU SETAN HUN SIM MUH UN w HA MAN HI BALER SA SUHE SANS HAM www VW I NIE waard 346 . SU 14 S1 w H 11 SH SIMIN 5444 51 AVE MAM VIE IMONIO WWW HT WI ME MI MM HOWN 14 SAUTI M SUS HU HIVI NUWE JU WW IN SMS JE BU MARI TOM MAN SMS IM SH 16 SA HAS MU WINS SI BASILI HU HUN NARE sus HUN IBAN JUMA SOLO UMN HUMU 11 HAM SU WEB w 4 SER SA TO HUS ME 15 $10MM 16 HANS SAN 140 DES ww TUI 1814 HU UT SET wat THE 1041 BUS $15 INATA 34 16 SUM SH S4 Www SA TRAIN SHIT TE JUST WW SUM SE SANTA HA SA SAINT 995 ma IS SAM U ST SU SMS SAN S SH SU SURUM SULU 1 INS WS 1011 $41