VLook-up is a powerful function that lets you find match and replace values based on an index. VLook-up is often used when information must be converted before being analyzed.
VLook-Up Tutorial
Practice
Complete the following cleaning step(s) on the practice tab of the workshop_data Excel file.
Use VLOOKUP to add a column that matches the city code with its corresponding city from the practice_reference tab. Name the column city.
