Next, in the RawData worksheet: enter the formulas to complete the two missing column entries (note: you must complete this step before proceeding to the creation of the pivot table). 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 customers data (including IDs, names, and states). 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 stocks data (including its ticker symbol, stock name, and sector).Raw DataCustomersStocks

\begin{tabular}{|l|l|l|} \hline CustomerlD & Customer Name & Customer State \\ \hline CN0714696 & Audrey Ward & North Carolina \\ \hline CN0284057 & Kailey Galloway & Arizona \\ \hline CN0498600 & Jasmine Knight & California \\ \hline CN0295222 & Rocco Schmitt & New Jersey \\ \hline CN0332508 & John Collins & New Mexico \\ \hline CN0386182 & Bryan Ortega & New Jersey \\ \hline CN0042247 & Robert Stevens & California \\ \hline CN0527715 & Alondra Lester & Colorado \\ \hline CN0602457 & Olivia Williams & Wisconsin \\ \hline CN0230940 & Jazlyn Riggs & Nevada \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline CustomerlD & Customer Name & Customer State \\ \hline CN0714696 & Audrey Ward & North Carolina \\ \hline CN0284057 & Kailey Galloway & Arizona \\ \hline CN0498600 & Jasmine Knight & California \\ \hline CN0295222 & Rocco Schmitt & New Jersey \\ \hline CN0332508 & John Collins & New Mexico \\ \hline CN0386182 & Bryan Ortega & New Jersey \\ \hline CN0042247 & Robert Stevens & California \\ \hline CN0527715 & Alondra Lester & Colorado \\ \hline CN0602457 & Olivia Williams & Wisconsin \\ \hline CN0230940 & Jazlyn Riggs & Nevada \\ \hline \end{tabular}