Skip to Main Content

Cleaning & Analyzing Data in Excel

This guide complements the Cleaning & Analyzing Data in Excel workshop


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


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.
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.