Next, in the RawData worksheet: enter formulas to complete the two missing column entries (note: you must complete this step before proceeding to the creation of the pivot table). 520 (no ch) Cinabidi saib In the State column (column C), enter a VLOOKUP() function that will find the state each customer lives in (based on the CustomerID (column B) in the RawData worksheet) using the Customers worksheet, which contains each customer's data (including IDs, names and states). Biw Now alla In the Sector column (column E), enter a VLOOKUP() function to find the sector for each stock (based on the Ticker symbol (column D) in the RawData worksheet) using the Stocks worksheet, which contains each stock's data (including its ticker symbol, stock name and sector). Paste Clipboard C2 BIU-E A 1 Transaction D 2 TRO93016275 3 TR093011962 4 TR093010648 5 TR093016432 6 TR093003876 7 TR093024190 8 TR093021236 9 TR093014330 10 TR093025402 11 TRO93022880 12 TR093017116 13 TRO93009306 14 TR093004193 15 TR093012693 16 TR093024338 17 TR093014340 18 TRO93011272 19 TR093023692 20 TR093013058 21 TRO93026660 Fore fe D E Ticker Sector Qty WMB Customer10 State CN0125990 CN0497737 CN0643891 CN0638518 CN0269465 CN0490169 CN0304846 CN0730348 CN0593831 CN0222810 CN0252105 CN0670145 CN0105700 CN0545525 CN0395362 CN0542473 CN0212689 CN0034309 CN0181248 CN0013372 Analysis RawData Customers Stocks Sectors States O 34 Aconsibility investigate 0 IR BOX RRC Aliment SWKS PLD KSU BWA IVZ ORCL A BRK-B AEP HBI NDAQ PG DE FITB TDC 4175 11450 9125 1775 1425 3125 8025 3800 11650 7850 10525 3675 11150 1300 4850 12025 9625 9900 $ 8875 3350 %% G H -UnitPrice Total Dollar Value Number $89.88 $96.21 $87.48 $35.18 $21.89 $29.42 $80.85 $62.91 $10,54 $126.49 $10.79 $38.91 $177.83 $63.82 $40.60 Conditional Format as Call Formatting Table Styles Styles $45.56 $18.06 $45.21 $127.83 $74.75 B $375,249.00 $1,101,604.50 $798,255.00 $62,444.50 $31,193.25 $91,937.50 5648,821.25 $239,058.00 $122,791.00 $992,946.50 $113,564.75 $142,994.25 $1,982,804.50 $82,966.00 $196,910.00 $547,859.00 $173,827.50 $447,579.00 $1,134,491.25 $250,412.50 D Insert Delete Format E DI 1 Customer 2 CN0499843 Customer Name Tyler Snyder 3 CN0172622 Adan Herman 4 CN0542689 Jasmine Knight 5 CN0089515 Joseph Nelson 6 CN0330499 Madilynn Mcneil 7 CND010638 Carter Stewart 8 CN0460948 Jensen Huynh 9 CN0106154 Kenzie Flynn 10 CN0438861 Brianna Rice 11 CN0128676 Jade Wong 12 CN0741020 Weston Schneider 13 CN0601370 Xavier Medina 14 CN0123424 Kira Mosley 15 CN0665935 Frank Mcclure. 16 CN0527713 Charlotte Thompson 17 CN0105110 Arianna Gray 18 CN0351759 Maxwell Silva 19 CN0575692 Alexa Marshall 20 CN0733132 Tatum Hickman 21 CN0132821 Omar Hodges Analysis RawData Readly Accessibility bevestigate Customer State New Jersey Texas California Missouri Mississippi Florida Georgia North Carolina New York Michigan Idaho Idaho Illinois Kansas Oregon Pennsylvania Pennsylvania Texas Wyoming Tennessee - D Customers Stocks Sectors States E F G H J M Next, in the RawData worksheet: enter formulas to complete the two missing column entries (note: you must complete this step before proceeding to the creation of the pivot table). 520 (no ch) Cinabidi saib In the State column (column C), enter a VLOOKUP() function that will find the state each customer lives in (based on the CustomerID (column B) in the RawData worksheet) using the Customers worksheet, which contains each customer's data (including IDs, names and states). Biw Now alla In the Sector column (column E), enter a VLOOKUP() function to find the sector for each stock (based on the Ticker symbol (column D) in the RawData worksheet) using the Stocks worksheet, which contains each stock's data (including its ticker symbol, stock name and sector). Paste Clipboard C2 BIU-E A 1 Transaction D 2 TRO93016275 3 TR093011962 4 TR093010648 5 TR093016432 6 TR093003876 7 TR093024190 8 TR093021236 9 TR093014330 10 TR093025402 11 TRO93022880 12 TR093017116 13 TRO93009306 14 TR093004193 15 TR093012693 16 TR093024338 17 TR093014340 18 TRO93011272 19 TR093023692 20 TR093013058 21 TRO93026660 Fore fe D E Ticker Sector Qty WMB Customer10 State CN0125990 CN0497737 CN0643891 CN0638518 CN0269465 CN0490169 CN0304846 CN0730348 CN0593831 CN0222810 CN0252105 CN0670145 CN0105700 CN0545525 CN0395362 CN0542473 CN0212689 CN0034309 CN0181248 CN0013372 Analysis RawData Customers Stocks Sectors States O 34 Aconsibility investigate 0 IR BOX RRC Aliment SWKS PLD KSU BWA IVZ ORCL A BRK-B AEP HBI NDAQ PG DE FITB TDC 4175 11450 9125 1775 1425 3125 8025 3800 11650 7850 10525 3675 11150 1300 4850 12025 9625 9900 $ 8875 3350 %% G H -UnitPrice Total Dollar Value Number $89.88 $96.21 $87.48 $35.18 $21.89 $29.42 $80.85 $62.91 $10,54 $126.49 $10.79 $38.91 $177.83 $63.82 $40.60 Conditional Format as Call Formatting Table Styles Styles $45.56 $18.06 $45.21 $127.83 $74.75 B $375,249.00 $1,101,604.50 $798,255.00 $62,444.50 $31,193.25 $91,937.50 5648,821.25 $239,058.00 $122,791.00 $992,946.50 $113,564.75 $142,994.25 $1,982,804.50 $82,966.00 $196,910.00 $547,859.00 $173,827.50 $447,579.00 $1,134,491.25 $250,412.50 D Insert Delete Format E DI 1 Customer 2 CN0499843 Customer Name Tyler Snyder 3 CN0172622 Adan Herman 4 CN0542689 Jasmine Knight 5 CN0089515 Joseph Nelson 6 CN0330499 Madilynn Mcneil 7 CND010638 Carter Stewart 8 CN0460948 Jensen Huynh 9 CN0106154 Kenzie Flynn 10 CN0438861 Brianna Rice 11 CN0128676 Jade Wong 12 CN0741020 Weston Schneider 13 CN0601370 Xavier Medina 14 CN0123424 Kira Mosley 15 CN0665935 Frank Mcclure. 16 CN0527713 Charlotte Thompson 17 CN0105110 Arianna Gray 18 CN0351759 Maxwell Silva 19 CN0575692 Alexa Marshall 20 CN0733132 Tatum Hickman 21 CN0132821 Omar Hodges Analysis RawData Readly Accessibility bevestigate Customer State New Jersey Texas California Missouri Mississippi Florida Georgia North Carolina New York Michigan Idaho Idaho Illinois Kansas Oregon Pennsylvania Pennsylvania Texas Wyoming Tennessee - D Customers Stocks Sectors States E F G H J M