How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
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/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 канала Tuts+ Computer Skills
See the companion tutorial on Tuts+ at https://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 канала Tuts+ Computer Skills
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Vlookup simply explainedExcel VLOOKUP With Multiple WorkbooksDon't Use Excel Filters! Use This Incredible Excel Formula Instead ...Extract Data based on a Drop-Down List selection in ExcelHow to Compare Two Excel Sheets (and find the differences)50 Ultimate Excel Tips and Tricks for 2020How to make a data connection between two Excel workbooksHow to use Excel Index Match (the right way)Excel: INDEX and MATCHVLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532Index Match with Multiple CriteriaAdvanced PivotTables: Combining Data from Multiple SheetsAdvanced Excel - VLOOKUP BasicsExcel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)Top 10 Most Important Excel Formulas - Made Easy!Creating Easy Data Entry Forms in ExcelTop 25 Excel 2016 Tips and TricksCompare Two Lists Using the VLOOKUP FormulaIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)39 - Extract Data from a Table based on User Selection in Excel using Power Query