Lookup Functions
In this course we cover some basic lookup functions: VLOOKUP, HLOOKUP, INDEX(MATCH), and XLOOKUP. Use these functions to combine information from different sources. Includes practice problems. Free preview available!
Course curriculum
-
1
Lookup Functions
-
Lookup Functions Intro and File
FREE PREVIEW -
VLOOKUP Basics
FREE PREVIEW -
HLOOKUP
-
INDEX(MATCH)
-
XLOOKUP
-
VLOOKUP Approximate Match
-
VLOOKUP Tricks
-
-
2
Lookup Practice Problems
-
Practice Problem Downloads
-
Practice Problems Video
-
-
3
Feedback
-
Feedback for the Course
-