Key Lookup functions- covered in Intermediate course
Below a listing of what you would have learnt in the Intermediate course which feeds into this Advanced course.
Please check that you are comfortable with these items.
- VLOOKUP explained in simple terms
- Build your first VLOOKUP
- The many uses of an exact match VLOOKUP (FALSE or Zero at the end)