Download Practice Sheet For Vlookup – 2

Builds on the basics with a slightly larger dataset. Function covered: VLOOKUP. Difficulty: Beginner-Intermediate.

What you will practise:

• Using VLOOKUP across more rows and columns
• Locking the table array with absolute references ($)
• Copying a VLOOKUP formula down a column correctly