Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VLOOKUP & XLOOKUP in Excel
VLOOKUP
1. VLOOKUP Intro
2. What is VLOOKUP (1:22)
3. VLOOKUP Syntax (6:01)
4. VLOOKUP Range_lookup FALSE (6:29)
5. VLOOKUP Range_lookup TRUE (6:02)
6. VLOOKUP Rules (5:48)
7. VLOOKUP NA Errors (6:18)
8. VLOOKUP Wildcards (10:32)
9. VLOOKUP Insert Function (4:00)
10. VLOOKUP Across Different Tabs (7:19)
XLOOKUP
1. What is XLOOKUP (0:58)
2 XLOOKUP Syntax (7:33)
3. XLOOKUP Rules (5:06)
4. XLOOKUP NA Error (3:16)
5. XLOOKUP Match_Mode (8:34)
6. XLOOKUP Search_Mode (6:21)
7. XLOOKUP Wildcards (10:52)
8. XLOOKUP Horizontal Lookup (4:09)
9. XLOOKUP Across Different Spreadsheets (3:14)
10. XLOOKUP Final Example (6:58)
5. XLOOKUP Match_Mode
Complete and Continue