In this section, you can practice your VLOOKUP skills on additional exercise files.
Download or copy the exercise files and work through the suggested problems. The correct VLOOKUP function is provided for you to check your work.
Acquiring the practice workbook
To complete the additional VLOOKUP exercises, you will need to access the practice workbook.
Downloading the practice workbook for Microsoft Excel
If working in Microsoft Excel, you will download and extract the workbook.
- To begin downloading the practice workbook, click the following button:
For detailed instructions on downloading and extracting files in Google Chrome or Firefox, visit Getting Started with Exercise Files.
Copying the practice workbook in Google Sheets
In Google Sheets, you will copy the workbook to your Google Drive.
- To begin copying the practice workbook in a new browser window,
Right-click Copy practice workbook, Click Open link in new window
The file begins to open in a new window of the web browser. Before the document will open and can be edited, we need to make a copy of it.
Move to the new browser window.
- To copy the workbook file, in the browser window,
Click 
A copy of the file is now open and, by default, is saved in your Google Drive. The filename now has the words "Copy of" at the beginning.
Practicing the VLOOKUP function
Take some time to solve the following VLOOKUP problems. Expand the accordion to see the correct VLOOKUP function and check your work.
- To enter the VLOOKUP function, in cell B2, type:
=VLOOKUP(B1,A6:E293,5,FALSE)
- To enter the VLOOKUP function, in cell H6, type
=VLOOKUP(G6,Fees!$A$2:$B$24,2,FALSE)
- To add the Residence Hall area, in cell A3, type:
Residence Hall
- To enter the VLOOKUP function, in cell B3, type:
=VLOOKUP(B1,$A$6:$K$293,11,FALSE)
- To enter the VLOOKUP function, in cell C2, type:
=VLOOKUP(B2,$F$4:$G$8,2,TRUE)
- To enter the VLOOKUP function, in cell L2, type:
=VLOOKUP(A6,TestScores!$A$2:$C$39,3,FALSE)