HDTutorial
EN
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

5,381,397 views October 31, 2014 15:54

Watch on YouTube
ChannelTuts+ Computer Skills

In brief

Master three powerful Excel and Google Sheets functions—VLOOKUP, MATCH, and INDEX—to pull specific columns of data from one table into another, even across sheets or workbooks. Perfect for organizing or analyzing data efficiently.

Questions & answers

Does this work in both Excel and Google Sheets?

Yes, the tutorial covers VLOOKUP, MATCH, and INDEX in both Excel (Windows and Mac) and Google Sheets.

Description from the creator

When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows.

See the companion tutorial on Tuts+ at computers.tutsplus.com/tutorials/how-to-extract….

By Bob Flisser.

About this tutorial

Tuts+ Computer Skills published this 15:54 video tutorial on October 31, 2014. It has been watched 5,381,397 times on YouTube.

Duration
15:54
Published
October 31, 2014
Views
5,381,397
Likes
19,152

Tags

Share

This tutorial in other languages