Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)
Need to learn all about VLOOKUP? Microsoft Excel MVP & Highline College Professor, Mike “excelisfun” Girvin, presents 15 amazing VLOOKUP examples, from the basics to advanced.
Download Excel START File: https://excelisfun.net/files/StartFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
Download Source file: https://excelisfun.net/files/SourceData.xlsx
Download Excel FINISHED File: https://excelisfun.net/files/FinishedFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
In this video Learn all about VLOOKUP. Learn from Basics to Advanced. See 12 amazing examples that will help you become a VLLOKUP Excel Master! Video taught by Microsoft Excel MVP and Excel YouTuber, Mike Girvin.
Topics:
(00:06) Introduction
1. (01:32) VLOOKUP is everywhere
(04:24) The different between Exact Match & Approximate Match Lookup
2. (06:00) VLOOKUP to Lookup Product Price (Exact Match Lookup)
3. (12:25) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup)
4. (18:32) Data Validation List & VLOOKUP
5. (21:45) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References.
6. (27:00) Dynamic Lookup Table: Excel Table feature
7. (31:47) Dynamic Data Source: Use Power Query to import Lookup Table
8. (36:14) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup)
9. (41:00) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information)
10. (48:02) Fuzzy Lookup = Incomplete Lookup Value
11. (51:50) VLOOKUP & IFNA Functions to Avoid Errors
12. (53:05) Partial Text Lookup & Converting Text Number to Number
13. (56:28) Avoid Zeros from VLOOKUP to Empty Cells
14. (58:27) Multiple Table Lookup with VLOOKUP and INDIRECT Functions
15. (01:04:40) Two Lookup Values
(01:08:29)Summary
Видео Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) канала ExcelIsFun
Download Excel START File: https://excelisfun.net/files/StartFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
Download Source file: https://excelisfun.net/files/SourceData.xlsx
Download Excel FINISHED File: https://excelisfun.net/files/FinishedFileMysteriesOfVLOOKUPRevealedEMT1514.xlsx
In this video Learn all about VLOOKUP. Learn from Basics to Advanced. See 12 amazing examples that will help you become a VLLOKUP Excel Master! Video taught by Microsoft Excel MVP and Excel YouTuber, Mike Girvin.
Topics:
(00:06) Introduction
1. (01:32) VLOOKUP is everywhere
(04:24) The different between Exact Match & Approximate Match Lookup
2. (06:00) VLOOKUP to Lookup Product Price (Exact Match Lookup)
3. (12:25) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup)
4. (18:32) Data Validation List & VLOOKUP
5. (21:45) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References.
6. (27:00) Dynamic Lookup Table: Excel Table feature
7. (31:47) Dynamic Data Source: Use Power Query to import Lookup Table
8. (36:14) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup)
9. (41:00) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information)
10. (48:02) Fuzzy Lookup = Incomplete Lookup Value
11. (51:50) VLOOKUP & IFNA Functions to Avoid Errors
12. (53:05) Partial Text Lookup & Converting Text Number to Number
13. (56:28) Avoid Zeros from VLOOKUP to Empty Cells
14. (58:27) Multiple Table Lookup with VLOOKUP and INDIRECT Functions
15. (01:04:40) Two Lookup Values
(01:08:29)Summary
Видео Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft ExcelA Real-Life Excel Test from a Job Interview: Can You Pass??Data cleaning in Excel - 10 tricks *PROs* use all the timeExcel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, KeyboardsE-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?How to use Power Pivot in ExcelExcel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples)Return Multiple Match Results in Excel (2 methods)Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520Excel VLOOKUP Function - All You Need To Know5 Excel Functions YOU NEED in 2021Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)How to use VLOOKUP in Excel - Complete TutorialINDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)How to Pass Microsoft Excel Job Test: Questions and Answers15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included