Master the essential Excel VLOOKUP function in this comprehensive video tutorial led by an Excel MVP and renowned YouTuber. Explore 26 key topics, including vertical and horizontal lookups, handling errors, data validation, named ranges, formula elements, and advanced techniques like partial text lookups and two-way lookups. Learn to work with tables across different sheets and workbooks, show full records, and utilize functions like CHOOSE, MATCH, and TRIM. Discover how to handle complex scenarios such as variable tax rates and dynamic ranges using the Table feature. Download accompanying Excel files to practice along and solidify your understanding of this crucial Excel skill.
Overview
Syllabus
2. Why so common? Because everyone needs to look stuff up min
3. VLOOKUP Delivers a value to a cell: Extract Match min
4. VLOOKUP #N/A and IFERROR or IF min
5. VLOOKUP and Data Validation min
6. VLOOKUP with Named Range min
7. VLOOKUP as Formula Element min
8. HLOOKUP = H = Horizontal min
9. VLOOKUP Delivers a value to a cell: Approximate Match min
10. VLOOKUP with table on different sheet min
11. VLOOKUP with table in different workbook min
12. Show Full Record: Numbers above column header min
13. Show Full Record horizontally: COLUMNS Function min
14. Show Full Record vertically: ROWS Function min
15. Show Full Record: MATCH Functions min
16. Two Lookup Values: Add join column as first column in table min
17. Two Lookup Values: Join columns in formula and use CHOOSE function min
18. Partial Text Lookup: LEFT and SEARCH Functions min
19. Partial Text Lookup: MID Function min
20. Partial Text Lookup: RIGHT Function min
21. TRIM and VLOOKUP: Space in lookup value min
22. TRIM and VLOOKUP: Space in 1st column of table min
23. VLOOKUP with 3 lookup tables: CHOOSE Function min
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH min
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula min
26. VLOOKUP and Table feature for Dynamic ranges min
Taught by
ExcelIsFun
