LogoLogo
The Fundamentals of Data-driven Storytelling
The Fundamentals of Data-driven Storytelling
  • About this course
    • Course Introduction
  • Module 1 - Find
    • 1.1 How to Find Data for Storytelling and journalism
      • Starting with a question
      • Open data portals and platforms
      • Other sources of data
    • 1.2 How to get better data from a Goolge Search
      • Searching for filetypes and formats
      • More on Advanced Search operators
      • Other common Google Search operators
    • 1.3 Sourcing your own data
      • Creating a Google Form for Research
      • Creating a questionnaire with TypeForm
      • Using quizzes and comments as a sources of data
  • Module 2 - Get
    • 2.1 Turning websites and PDFs into machine readable data
      • Scraping data with Tabula
    • 2.2 An introduction to spreadsheet software
      • Google Sheets, Microsoft Excel and Libre Office Calc.
      • Finding your way around a spreadsheet
      • Simple web scraping with Google Sheets
  • Module 3 - Verify
    • 3.1 Can I use this data in my work?
      • Initial steps for verification
      • What do these column headings mean?
  • Module 4 - Clean
    • 4.1 What to do with disorganised data?
      • Why is clean data important?
      • Keep your data organised
      • Cleaning data cheatsheet
  • Module 5 - Analyse
    • 5.1 What is the story within the data?
      • Spreadsheet rows, columns, cells and tabs
        • Spreadsheet formats, forumlas and essential shortcuts
          • Using the VLOOKUP Function
            • Combine Data From Multiple Spreadsheets
    • 5.2 How to turn numbers into stories
  • Module 6 - Visualise
    • 6.1 Ways we visualise data
    • 6.2 Why we visualize Data
    • 6.3 How to visualise data
  • Course Testing & Feedback
    • ⏱️Quick course exam
    • 🎓Extended course exam
    • 📝Survey and feedback
Powered by GitBook
On this page
  • How to get started
  • Examples
  • Vertical lookup.
  1. Module 5 - Analyse
  2. 5.1 What is the story within the data?
  3. Spreadsheet rows, columns, cells and tabs
  4. Spreadsheet formats, forumlas and essential shortcuts

Using the VLOOKUP Function

Vlookup - a great function to know, though if it may seem confusing at first.

Vlookup - a great function to know, though if it may seem confusing at first.

It is simple to use if:

  1. Ensure you have the same unique identifier on both datasets.

  2. The datasets that you want to join are in a single document, with each dataset on a separate worksheet.

  3. Ensure your unique identifier is in col A of the dataset you are sourcing the information from.

Remember to remove all data filters!

How to get started

There are four pieces of information that you will need in order to build the VLOOKUP syntax:

  1. The value you want to look up, also called the lookup value.

  2. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.

  3. The column number in the range that contains the return value. For example, if you specify B2:D11 as the range, you should count B as the first column, C as the second, and so on.

  4. Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you don't specify anything, the default value will always be TRUE or approximate match.

Now put all of the above together as follows:

=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

Examples

Here are a few examples of VLOOKUP:

Example 1

Example 2

Example 3

Example 4

Example 5

Vertical lookup.

Searches for a value in the first column of a range. If it finds a match, it takes that row, and returns the value in the cell for the specified column.

Search_key

The value you want to search for. The unique identifier that is common to both datasets.

Range

The block of data in which contains the search_key and return a value. NB: the Vlookup function searches for the search_key in the first column of this range

Index

A number, specifying the position of the column in the range , that contains the values we wish to get (1-indexed)

[is_sorted]

For most purposes, this will always be FALSE

PreviousSpreadsheet formats, forumlas and essential shortcutsNextCombine Data From Multiple Spreadsheets

Last updated 2 years ago