Course

# Data Wrangling with VLOOKUP in Spreadsheets

In this tutorial, you will get an overview of how to use the VLOOKUP function and also a basic explanation of INDEX-MATCH.

Mar 2019 · 11 min read

Related Courses

2 hr

21K

Course

### Intermediate Google Sheets

4 hr

48.3K

Course

### Data Analysis in Google Sheets

3 hr

12.5K

See More

RelatedSee MoreSee More

tutorial

### Data Wrangling with INDEX-MATCH in Spreadsheets

In this tutorial, you will get an overview of how to use the INDEX-MATCH function in spreadsheets.

Francisco Javier Carrera Arias

11 min

tutorial

### How to Use HLOOKUP in Excel

A beginner-friendly, comprehensive tutorial in mastering the HLOOKUP function in Microsoft Excel.

Arunn Thevapalan

6 min

tutorial

### How to Combine VLOOKUP() with IF() in Excel

Combine VLOOKUP() with IF() for efficient data analysis, including conditional lookups, error handling, and dynamic column indexing.

Laiba Siddiqui

10 min

tutorial

### How to Do a VLOOKUP() with Multiple Criteria

Master the art of using VLOOKUP() with multiple criteria in Excel. Explore advanced techniques like helper columns and the CHOOSE() function.

Laiba Siddiqui

10 min

tutorial

### Getting Started with Spreadsheets

This tutorial will give you a basic understanding of the terminology in spreadsheets along with learning how to create a basic table.

Ryan Sheehy

5 min

tutorial

### XLOOKUP() vs. VLOOKUP(): A Comparison for Excel Users

XLOOKUP() searches in any direction, defaults to exact matches, and has built-in error handling, while VLOOKUP() only searches right and needs manual column indexing.

Laiba Siddiqui

11 min