In the State column (column C), enter a VLOOKUP() function that will find the state each customer
Fantastic news! We've Found the answer you've been seeking!
Question:
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).
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).
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date: