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.

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.

To complete the additional VLOOKUP exercises, you will need to access the practice workbook.

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.

In **Google Sheets**, you will copy the workbook to your Google Drive.

- To begin copying the practice workbook, click the following button:

The file begins to open in a web browser. Before the document will open and can be edited, we need to make a copy of it.

- To copy the workbook file,

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.

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)