VLOOKUP

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

The power of VLOOKUP()

  • VerticalLOOKUP: search for information in a table based on search keys

An example of a situaton where VLOOKUP can be used: there is a main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

The power of VLOOKUP()

  • VerticalLOOKUP: search for information in a table based on search keys

The table containing the orders has been highlighted as the main table, and the table containing the product information has been highlighted as the lookup table.

Data Analysis in Google Sheets

VLOOKUP() syntax

VLOOKUP(search_key, range, index, [is_sorted])
  • search_key: The value in main table to search for in the lookup table
  • range: The range containing the lookup table (usually absolute references)
  • index: The column index in the lookup table to return
  • is_sorted: TRUE/FALSE to indicate is the lookup table is sorted
Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

VLOOKUP() example - stationary orders

VLOOKUP(search_key, range, index, [is_sorted])

A main table containing orders for different stationary products, and a products table containing the product names and prices.

Data Analysis in Google Sheets

Let's practice!

Data Analysis in Google Sheets

Preparing Video For Download...