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-data-from-a-spreadsheet-using-vlookup-match-and-index--cms-20641.
By Bob Flisser.
- How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX ( Download)
- 🗄 How to look for values in another table in Excel (INDEX + MATCH formulas) in 2 minutes ( Download)
- How to Do a VLOOKUP With Two Spreadsheets in Excel ( Download)
- How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP ( Download)
- Stop using VLOOKUP in Excel. Switch to INDEX MATCH ( Download)
- Extracting Data from a Spreadsheet using VLOOKUP, MATCH, & INDEX (Data Analysis on a spreadsheet) ( Download)
- How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX ( Download)
- How to Extract Data from a Spreadsheet using VLOOKUP, MATCH ( Download)
- How To Mastering the IF Function with Multiple Logical Conditions in Excel ( Download)
- Excel VLookup to Return Multiple Matches ( Download)
- Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel ( Download)
- VLookUp - How To Extract Data From an Excel Spreadsheet Given Customer ID Number ( Download)
- How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets ( Download)
- How to use Excel Index Match (the right way) ( Download)
- How to Extract Data from a spread sheet using VLOOKUP match and Index|Jay-Ann Channel ( Download)
