How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
5,247,975 views
About :
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 https://computers.tutsplus.com/tutori....
By Bob Flisser.
Tags :
Google AdSense
336 x 280
336 x 280
Learn Google Sheets & Excel Spreadsheets
861,433 views
3 years ago
3 years ago
Tuts+ Computer Skills
1,759,571 views
9 years ago
9 years ago
ExcelIsFun
5,417,038 views
10 years ago
10 years ago
Google Sheets Pull Data from Another Worksheet Based on Criteria | Use Multiple Criteria Cell Values
Chester Tugwell
116,214 views
2 years ago
2 years ago
Google AdSense
336 x 280
336 x 280