XLOOKUP | |||
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:08:00 | ||
XLOOKUP Wildcards | 00:11:00 | ||
XLOOKUP Horizontal Lookup | 00:04:00 | ||
XLOOKUP Across Different Spreadsheets | 00:03:00 | ||
XLOOKUP Final Example | 00:01:00 | ||
VLOOKUP | |||
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 | ||
Order Your Certificate | |||
Order Your Certificate Now | 00:00:00 |
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.