Course details

Welcome to VLOOKUP in Google Sheets - Step by Step

Learn one of the most effective functions used to locate data in your Google Sheets tables.

As a new or experienced Google Sheets user, this course will teach you VLOOKUP - a very useful function that will save you time when searching tables.

With this course, you will accomplish the following:

  • Learn what a searchable table is and how to create your own.
  • See how the VLOOKUP function is broken into components and how to utilize each and every component effectively.
  • Create a basic VLOOKUP Google Sheets application.
  • Make your VLOOKUP function interactive to search tables without editing your formula each time.
  • How to use VLOOKUP between two sheets on the same spreadsheet as well as on completely different spreadsheets.
Updated on 02 January, 2018
Courses you can instantly connect with... Do an online course on Google starting now. See all courses