In the 2016 Sales Shipped 2017 sheet, create a label in cell H1 named SalesAmount to extend the table to include this column. This amount, along with the InvCostReliefAmount which is already part of the data in the sheet, will be needed to create an adjusting entry to correct sales and cost of goods sold if some transactions are found in this analysis. Create a formula in H2 using a function from the lookup and reference category of functions to return the sales amount from an existing table in another worksheet. If there is no matching sale, then the formula should return the null or empty string. When constructing this formula, you should use structured cell references. Also, format the amounts in both columns with the Accounting format. Autofit both columns that have dollar amounts. Hint: Hint: The lookup table used in this formula will be a subset of the ARData table. The null or empty string is simply the use of two double quotes right next to one another (i.e., "") within a formula.

Please write the formula to use. Thanks for the help

* CUR VIEW Insert Format Tools Data Window Help AutoSave OFF osvo- Bertheaud_Clothing Tech - Pre-Project Home Insert Draw Page Layout Formulas Data Review View Developer Table Arial A A == = LOLE General BIU av A. OU $ % 38.00 10 Paste H6 sales, ShipNUM FedEx CustNul CustName Invoice Dal ShipDal InvCostReliefAmour 100124 42377 1168 Bigmart 1/8/16 1/8/16 $ 18.044.15 100130 42380 1836 Runner's Market 1/11/16 1/11/16 $ 33,061.17 100126 42389 1863 Fit N Fun 1/20/16 1/20/16 $ 6.013.06 100132 42392 1839 Southem Runners 1/23/16 1/23/16 $ 38,844.00 100136 42399 1861 Family Fit 1/30/16 1/30/16 $ 12,487.04 100546 42401 1863 Fit N Fun 2/1/16 2/1/16 $ 5,793.07 100142 42405 1168 Bigmart 2/5/16 2/5/16 $ 12,955.47 100163 42405 1168 Bigmart 2/5/16 2/5/16 $ 9,372.60 100172 42408 1861 Family Fit 2/8/16 2/8/16 $ 6,281.88 100174 42408 1863 Fit N Fun 2/8/16 2/8/16 $ 5,864.64 100186 42411 1168 Bigmart 2/11/16 2/11/16 $ 9,486.90 100196 42413 1861 Family Fit 2/13/16 2/13/16 $ 6,281.88 100215 42415 1863 Fit N Fun 2/15/16 2/15/16 $ 5,864.64 100219 42419 1168 Bigmart 2/19/16 2/19/16 $ 8.892.54 100245 42420 1861 Family Fit 2/20/16 2/20/16 $ 6,459.52 100247 42422 1863 F N Fun 2/22/16 2/22/16 $ 5,864.64 100249 42425 1836 Runner's Market 2/25/16 2/25/16 $ 16,561.38 100250 42425 1168 Bigmart 2/25/16 2/25/16 S 9,144.00 100270 42426 1839 Southem Runners 2/26/16 2/26/16 $ 20,750.00 100309 42433 1836 Runner's Market 3/4/16 3/4/16 $ 15,955.47 100310 42433 1168 Bigmart 3/4/16 3/4/16 $ 9,486.90 100315 42435 1839 Southem Runners 3/6/16 3/6/16 $ 19,750.00 100162 42436 1836 Runner's Market 3/7/16 3/7/16 $ 16,117.44 100320 42436 1861 Family Fit 3/7/16 3/7/16 S 6.716.21 100167 42437 1839 Southem Runners 3/8/16 3/8/16 $ 20,000.00 100322 42437 1863 Fit N Fun 3/8/16 3/8/16 $ 6,275.46 100185 42440 1836 Runner's Market 3/11/163 /11/16 $ 16,117.44 100544 42440 1836 Runner's Market 3/11/16 3/11/16 $ 15,896.22 100191 42441 1839 Southem Runners 3/12/16 3/12/16 $ 19,450.00 100324 42441 1168 Bigmart 3/12/16 3/12/16 $ 8,476.00 100328 42441 1839 Southem Runners 3/12/16 3/12/16 S 20,000.00 100346 42443 1861 Family Ft 3/14/16 3/14/16 $ 6,470.50 100347 42444 1863 Fit N Fun 3/15/16 3/15/16 S 5,196.46 35 100218 42448 1836 Runner's Market 3/19/16 3/19/16 $ 15.753.50 100240 42448 1839 Southem Runners 3/19/16 3/19/16 S 20,500.00 100350 42454 1836 Runner's Market 3/25/16 3/25/16 $ 512.50 100351 42454 1168 Bigmart 3/25/16 3/25/16 $ 5,393.60 100356 42455 1839 Southem Runners 3/26/16 3/26/16 $ 20.750.00 100378 42457 1861 Family Fit 3/28/16 3/28/16 $ 6,388.59 100380 42458 1863 Fit N Fun 3/29/16 3/29/16 S 6.199.86 100397 42461 1168 Bigmart 4/1/16 4/1/16 $ 9,486.90 100459 42464 1863 Fit N Fun 4/4/16 4/4/16 $ 5,718.02 100461 42465 1861 Family Fit 4/5/16 4/5/16 $ 6,621.01 100481 42468 1836 Runner's Market 4/8/16 4/8/16 S 15,955.47 100482 42468 1168 Bigmart 4/8/16 4/8/16 $ 9.486.90 100504 42469 1839 Southem Runners 4/9/16 4/9/16 $ 20,000.00 100526 42471 1861 Family Fit 4/11/16 4/11/16 $ 6.552.40 100565 42472 1863 F N Fun 4/12/16 4/12/16 $ 6,199.86 100584 42475 1836 Runner's Market 4/15/16 4/15/16 $ 16,561.38 100585 42475 1168 Big mart 4/15/16 4/15/16 S 9,144.00 100624 42476 1839 Southem Runners 4/16/16 4/16/16 $ 20.750.00 100646 42478 1861 Family Fit 4/18/16 4/18/16 S 6,552.40 100645 42479 1863 Fit N Fun 4/19/16 4719/16 $ 6,048.64 100651 42482 1836 Runner's Market 4/22/16 4/22/16 S 15,266.00 Misc 2016 AR-Original 2016 Inventory Relief-Original 2016 AR Data 2016 Sales Shipped 201 Ready T * CUR VIEW Insert Format Tools Data Window Help AutoSave OFF osvo- Bertheaud_Clothing Tech - Pre-Project Home Insert Draw Page Layout Formulas Data Review View Developer Table Arial A A == = LOLE General BIU av A. OU $ % 38.00 10 Paste H6 sales, ShipNUM FedEx CustNul CustName Invoice Dal ShipDal InvCostReliefAmour 100124 42377 1168 Bigmart 1/8/16 1/8/16 $ 18.044.15 100130 42380 1836 Runner's Market 1/11/16 1/11/16 $ 33,061.17 100126 42389 1863 Fit N Fun 1/20/16 1/20/16 $ 6.013.06 100132 42392 1839 Southem Runners 1/23/16 1/23/16 $ 38,844.00 100136 42399 1861 Family Fit 1/30/16 1/30/16 $ 12,487.04 100546 42401 1863 Fit N Fun 2/1/16 2/1/16 $ 5,793.07 100142 42405 1168 Bigmart 2/5/16 2/5/16 $ 12,955.47 100163 42405 1168 Bigmart 2/5/16 2/5/16 $ 9,372.60 100172 42408 1861 Family Fit 2/8/16 2/8/16 $ 6,281.88 100174 42408 1863 Fit N Fun 2/8/16 2/8/16 $ 5,864.64 100186 42411 1168 Bigmart 2/11/16 2/11/16 $ 9,486.90 100196 42413 1861 Family Fit 2/13/16 2/13/16 $ 6,281.88 100215 42415 1863 Fit N Fun 2/15/16 2/15/16 $ 5,864.64 100219 42419 1168 Bigmart 2/19/16 2/19/16 $ 8.892.54 100245 42420 1861 Family Fit 2/20/16 2/20/16 $ 6,459.52 100247 42422 1863 F N Fun 2/22/16 2/22/16 $ 5,864.64 100249 42425 1836 Runner's Market 2/25/16 2/25/16 $ 16,561.38 100250 42425 1168 Bigmart 2/25/16 2/25/16 S 9,144.00 100270 42426 1839 Southem Runners 2/26/16 2/26/16 $ 20,750.00 100309 42433 1836 Runner's Market 3/4/16 3/4/16 $ 15,955.47 100310 42433 1168 Bigmart 3/4/16 3/4/16 $ 9,486.90 100315 42435 1839 Southem Runners 3/6/16 3/6/16 $ 19,750.00 100162 42436 1836 Runner's Market 3/7/16 3/7/16 $ 16,117.44 100320 42436 1861 Family Fit 3/7/16 3/7/16 S 6.716.21 100167 42437 1839 Southem Runners 3/8/16 3/8/16 $ 20,000.00 100322 42437 1863 Fit N Fun 3/8/16 3/8/16 $ 6,275.46 100185 42440 1836 Runner's Market 3/11/163 /11/16 $ 16,117.44 100544 42440 1836 Runner's Market 3/11/16 3/11/16 $ 15,896.22 100191 42441 1839 Southem Runners 3/12/16 3/12/16 $ 19,450.00 100324 42441 1168 Bigmart 3/12/16 3/12/16 $ 8,476.00 100328 42441 1839 Southem Runners 3/12/16 3/12/16 S 20,000.00 100346 42443 1861 Family Ft 3/14/16 3/14/16 $ 6,470.50 100347 42444 1863 Fit N Fun 3/15/16 3/15/16 S 5,196.46 35 100218 42448 1836 Runner's Market 3/19/16 3/19/16 $ 15.753.50 100240 42448 1839 Southem Runners 3/19/16 3/19/16 S 20,500.00 100350 42454 1836 Runner's Market 3/25/16 3/25/16 $ 512.50 100351 42454 1168 Bigmart 3/25/16 3/25/16 $ 5,393.60 100356 42455 1839 Southem Runners 3/26/16 3/26/16 $ 20.750.00 100378 42457 1861 Family Fit 3/28/16 3/28/16 $ 6,388.59 100380 42458 1863 Fit N Fun 3/29/16 3/29/16 S 6.199.86 100397 42461 1168 Bigmart 4/1/16 4/1/16 $ 9,486.90 100459 42464 1863 Fit N Fun 4/4/16 4/4/16 $ 5,718.02 100461 42465 1861 Family Fit 4/5/16 4/5/16 $ 6,621.01 100481 42468 1836 Runner's Market 4/8/16 4/8/16 S 15,955.47 100482 42468 1168 Bigmart 4/8/16 4/8/16 $ 9.486.90 100504 42469 1839 Southem Runners 4/9/16 4/9/16 $ 20,000.00 100526 42471 1861 Family Fit 4/11/16 4/11/16 $ 6.552.40 100565 42472 1863 F N Fun 4/12/16 4/12/16 $ 6,199.86 100584 42475 1836 Runner's Market 4/15/16 4/15/16 $ 16,561.38 100585 42475 1168 Big mart 4/15/16 4/15/16 S 9,144.00 100624 42476 1839 Southem Runners 4/16/16 4/16/16 $ 20.750.00 100646 42478 1861 Family Fit 4/18/16 4/18/16 S 6,552.40 100645 42479 1863 Fit N Fun 4/19/16 4719/16 $ 6,048.64 100651 42482 1836 Runner's Market 4/22/16 4/22/16 S 15,266.00 Misc 2016 AR-Original 2016 Inventory Relief-Original 2016 AR Data 2016 Sales Shipped 201 Ready T