Skip to content
GridBelt
Excel Test
Practice
Programs
Pricing
Sign in
Start the free test
Excel Test
Practice
Programs
Pricing
Sign in
Create account
Start the free test
Practice
Lookups
XLOOKUP Practice Exercises — and VLOOKUP vs XLOOKUP
Replace VLOOKUP, look left and match on two criteria.
3 exercises, about 22 min
36
Replace VLOOKUP with XLOOKUP
Intermediate
~6 min
Intermediate, ~6 min
37
Look left: employee ID by email
Expert
~6 min
Expert, ~6 min
38
Two-criteria lookup (product and region)
Expert
~10 min
Expert, ~10 min