Hello, this is a auditing and data validation question. I've attached the question and tables in the photos below. I'm set on steps 1 and 3, but stuck on step 2. I'm using the Vlookup function in column G. I'm entering it wrong and I'm not sure how to fix it. Please are you able to show me what I'm doing wrong and provide steps on how to fix it? Thanks much!

Auditing and Data Validation In the attached file Tools_Hwk3.xlsx, you will find two worksheets. One of the sheets is a sales journal for the month of January 2020. There is at least one error in each column, except column E. You are going to correct them, but more than that, you will add data validation and VLOOKUP so that most of these errors can't occur again. You'll find it easiest to add the data validation first. For this assignment, you should: 1. Use the Data Tools/Data Validation/Data Validation command on the Data tab to add data validation to columns A, C, and of the table on the "Sales Journal worksheet: 1. Column A should only contain dates in January 2020 2. Column C should only contain names from the list of product names on the "Pricing Table" worksheet 3. Column D should contain whole numbers that are between 1 and 50. 2. The item numbers in Column B don't always match the product in Column C. Put formulas in Column B of the journal table that use the VLOOKUP function to give the correct item numbers (item IDs). You will want to use the table on the worksheet "Pricing Table to do this. 3. Use the Data Tools/Data Validation/Circle Invalid Data command to circle errors on the "Sales Journal" worksheet. Now correct the errors that you can spot on the worksheet. Be sure to fill the "Error Table" as you fix the errors. You might want to come up with your own value to fix an error any value is fine as long as it does not violate the data validation criteria. $ % 2 Merge & Center Paste I B U fx =VLOOKUP(B2,Pricing Table,2,FALSE) G2 G H E D C Error 1 2 3 4 5 6 1 Date 2 January 1, 2020 3 January 2, 2020 January 3, 2020 January 4, 2020 6 January 5, 2020 7 January 6, 2020 8 January 7.2020 9 January 8, 2020 10 January 9.2020 11 January 10, 2020 12 January 11, 2020 13 January 12, 2020 14 January 13, 2020 15 January 14, 2020 16 January 15, 2020 17 January 16, 2020 18 January 17, 2020 19 January 18, 2020 20 January 19, 2020 21 January 20, 2020 22 January 21, 2020 23 January 22, 2020 24 January 23, 2020 25 January 24, 2020 26 January 25, 2020 27 January 26, 2020 28 January 27, 2020 29 January 28, 2020 30 January 29, 2020 31 January 30, 2020 32 33 Product ID Millennium PC P3 4980 ChromoJet Inkjet Printer 3665 ChromoJet Inkjet Printer 4980 Rudolf DSL Modem 7709 Bell DVD Drive 3665 ChromoJet Inkjet Printer 7708 Bell DVD Drive 6773 Millennium PC P3 6773 Millennium PC P3 4877 DataFlash Modem 56K 4980 Rudolf DSL Modem 6773 Millennium PC P3 3665 ChromoJet Inkjet Printer 4877 Data Flash Modem 56K 9248 Blue Island Laser Printer 4980 Rudolf DSL Modem 3665 ChromoJet Inkjet Printer 6777 Millennium PC P3 4877 DataFlash Modem 56K 6773 Millennium PC P3 3665 ChromoJet Inkjet Printer 4877 Data Flash Modem 56K 4877 Blue Island Laser Printer 4980 Rudolf DSL Modem 3665 ChromoJet Inkjet Printer 6777 Millennium PC P3 4877 Data Flash Modem 56K 6773 Millennium PC P3 3665 ChromoJet Inkjet Printer 7708 Bell DVD Drive 6773 Millennium PC P3 Units Sold Sales Price Total Sales 3 $ 142.53 $ 4 1 $ 774.95 $ 774.95 1$ 142.50 $ 142.50 12 $ 167.39 $ 2.008.68 1 $ 774.95 $ 774.95 3 $ 165.40 $ 496.20 2 $ 2,440.00 $4,880.00 1 $ 2.257.00 $ 2.257.00 2$ 117.02 $ 234.04 1 $ 125.70 S 125.70 2 $ 2,503.42 $ 5.006.84 2 $ 760.05 $ 1,520.10 2 $ 108.02 $ 216.04 11 $ 1.598.31 $ 1,598.31 3$ 157.45$ 47235 4 $ 774.95 $ 3.099.80 45 2,400.67 $ 9,602.68 5 $ 119.00 $ 595.00 7 $ 2,130.95 $14,916 65 50 $ 813.00 $ 40.650.00 4 $ 100.32 $ 401 28 5 $ 1,599.40 $7.997.00 85 168.10 $ 1.344.80 105 813.95 $ 8,139.50 35 2,400.67 $ 7.20201 1 $ 116.28 $ 116.28 $ 2.120.10 512,720.60 25 813.00 $ 1,628,00 05 165.785 1.492.02 25$ 2.135.00 $ 53,375.00 Column +#NA EN/A #N/A #N/A #N/A #N/A #N/A ENIA =N/A NIA #N/A #N/A NA N/A #NA #N/A ENA #NA NA WNIA #N/A ANA #N/A #NIA #N/A #N/A NIA #N/A #N/A Paste Paste BIU Av Merge 09 E F G H 1 Name 2 Bell DVD Drive 3 Blue Island Laser Printer 4 ChromoJet Inkjet Printer 5 DataFlash Modem 56K 6 Millennium PC P3 7 Rudolf DSL Modem B D ID Low Price High Price 7708 $ 134.23 $ 185.19 9248 $ 1,020.51 $ 1,734.87 3665 $ 627.72 $ 1,067.13 4877) $ 97.34 $ 125.47 6773 $ 1,700.88 $ 2,891.50 4980 $ 114.07 $ 168.92 10 11 13 20 21 22 23 24 25 26 27 28 29 30 31 32