n 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$).$