Lookup Functions - Excel Practice Online
13 free interactive exercises
Lookup functions pull the right value out of a big table. Practice VLOOKUP, HLOOKUP, XLOOKUP, and lookup basics online and free - the exact skills analysts use every day, drilled hands-on until they stick.
Lesson 11
VLOOKUP Function
FormulaLesson 49
HLOOKUP Function
FormulaLesson 58
VLOOKUP Practice
FormulaLesson 63
XLOOKUP Function
FormulaLesson 71
VLOOKUP Function 2
FormulaLesson 72
HLOOKUP Function 2
FormulaLesson 73
XLOOKUP Function 2
FormulaLesson 79
More VLOOKUP Practice
FormulaLesson 80
VLOOKUP Approximate Match
FormulaLesson 85
XLOOKUP
FormulaLesson 86
Dependent Drop-Down Lists
FormulaLesson 88
FILTER Function
FormulaLesson 95