- 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). Use the Customers worksheet to collect the states information as it contains each customer's 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). Use the Stocks worksheet to collect the stocks information as it contains each stock's data (including its ticker symbol, stock name and sector). Intomerio Customer Name C D E F G H N0716459 Waylon Brock Customar State N0571081 Austin Alvare? Georgia N0123986 Pablo Randolph Pernsylvania N0318887 Quentin Hendrix Arizona v0296761 Andy Conley Montana N0730721 Justin Grant Kansas - 0.372086 Julio Waller Texas N0205090 Brady Fitzgerald Washington N0031877 Jacqueline Yates New York v0529891 Dylan Murphy Illinois v0089713 Rowan Harding Pennsylvaria N0422084 Kolton Ayers California N0363962 Carter Stewart Illinois: N0289458 Ryker Santiago Pennsylvania N0197216 Texas v0091613 Frank Mcclure Maryland N0217261 Gunnar Morse Maryland Taylor Chung Massachusetts w0492392 Illinois N0243183 California N0232002 Alabama N0564463 New lersey v0744662 Washington v0325367 Harvey Forbes Mizona N0395362 Brooks Salinas South Carolina v0084914 Tennessee v0264873 Texas N0105110 New Jersey 424934 Texas Stocks Sectors States Analysis tie Erickson Customers Stocis