Course Curriculum
- 2 sections
- 20 lectures
- 00:00:00 total length
-
What is XLOOKUP?
00:01:00 -
XLOOKUP Syntax
00:08:00 -
XLOOKUP Rules
00:05:00 -
XLOOKUP NA Error
00:03:00 -
XLOOKUP match_mode
00:09:00 -
XLOOKUP search_mode
00:06:00 -
XLOOKUP Wildcards
00:11:00 -
XLOOKUP Horizontal Lookup
00:04:00 -
XLOOKUP Across Different Spreadsheets
00:03:00 -
XLOOKUP Final Example
00:07:00
-
Introduction
00:02:00 -
What is VLOOKUP?
00:01:00 -
VLOOKUP Syntax
00:06:00 -
VLOOKUP – Range_lookup FALSE
00:06:00 -
VLOOKUP – Range_lookup TRUE
00:06:00 -
VLOOKUP Rules
00:06:00 -
VLOOKUP NA Errors
00:06:00 -
VLOOKUP Wildcards
00:11:00 -
VLOOKUP Insert Function
00:04:00 -
VLOOKUP Across Different Tabs
00:07:00