Play all

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

Description:

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.

Excel VLOOKUP Function - All You Need to Know

ExcelIsFun

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Computer Science #Information Technology #Data Management #Data Validation

0:00 / 0:00