Excel VLOOKUP Exercises PDF with Answers: 6 Problems
Prologue
In this article, you’ll find six practice problems related to Excel VLOOKUP exercises in PDF with answers. You can download it for free.
The download links are at the bottom of this article. Furthermore, the solutions to the practice problems will be provided in the final section.
VLOOKUP Function Summary
The VLOOKUP function is used to lookup values vertically. The syntax of this function is:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
 lookup_value: the value you want to match
 table_array: the location to search for the value
 col_index_num: the column that contains the value
 [range_lookup]: sets the match for the value approximately or exactly.
The last parameter is optional. The default value is True (approximate match). Where False means an exact match.
You can also use 0 for an exact match and 1 for an approximate match.
Additionally, this function is case insensitive. So, EXCELFLASH or excelflash will be equal in this formula.
VLOOKUP Practice Problems
Now, you’ll find six VLOOKUP practice exercises.
Exercise 01: Basic VLOOKUP
Using the VLOOKUP function, retrieve the employee name from the ID numbers. Use the formula in the range C12:C15.
Exercise 02: VLOOKUP from Different Sheet
Find the name of the employee from the ID numbers. The table_array is on the sheet named source.
The following image is the source worksheet.
Exercise 03: Approximate VLOOKUP
A tax percentage is given for each of the five salary ranges. Return the applicable tax for the employees by applying an approximate match in the VLOOKUP function.
Exercise 04: Nested VLOOKUP
There are two tables for table_array. Find the salary from the IDs using the nested VLOOKUP functions.
Hint: Locate the name using the ID in the first VLOOKUP from the first table, and then return the salary using the name from the second table.
Exercise 05: Wildcard VLOOKUP
Locate the employee ID that has a partial match. For example, the first will look for a name that contains the word red, while the second will look for a name that begins with Tifa. Essentially, you must use the VLOOKUP function with the provided asterisk wildcard (*).
Exercise 06: Troubleshoot VLOOKUP Function
In this exercise, you’ll find five VLOOKUP related errors. Your task is to fix those errors. You shouldn’t use IFERROR, IFNA, or similar functions. The five errors are:
 VALUE! error
 Formula on the cell: =VLOOKUP(B12,$B$3:$D$8,0,0) use color on formula
 N/A error
 Formula on the cell: =VLOOKUP(B13,B4:D9,2,0)
 REF error
 Formula used: =VLOOKUP(B14,$B$3:$D$8,4,0)
 Wrong Output error
 Formula used: =VLOOKUP(B15,$B$3:$D$8,2,1)
 NAME error
 Formula used: =VLOKUP(B16,$B$3:$D$8,2,0)
Go through the formulas and think about what is wrong with each. Then, correct those and return the correct output. Hint: You will need to change the order of the dataset for one error.
Download File
You can download the PDF file and Excel VLOOKUP exercise files below.
VLOOKUP Exercises Excel Flash.xlsx
Bonus: Get the Google Sheets file for this topic.
Answers
Here, you can find the solution to the six VLOOKUP exercises. The formula is shown for the first cell only.
Exercise #  Formula/Solution 
1. Basic VLOOKUP  =VLOOKUP(B12,$B$3:$D$8,2,0) 
2. VLOOKUP from Different Sheet  =VLOOKUP(B3,Source!$B$3:$D$8,2,0) 
3. Approximate VLOOKUP  =VLOOKUP(C12,$B$3:$D$8,3,1) 
4. Nested VLOOKUP  =VLOOKUP(VLOOKUP(B12,$B$3:$C$8,2,0),$E$3:$F$8,2,0) 
5. Wildcard VLOOKUP  =VLOOKUP(B12,$B$3:$D$8,2,0) 
6. Troubleshoot VLOOKUP Function 

Epilogue
You’ve seen six exercises related to the Excel VLOOKUP exercises PDF with answers. If you’re having any trouble understanding the discussion on this topic, feel free to reach out to us. You can also follow Excel Flash on Twitter and YouTube.
I wanna thank you for all the hard work you are doin. Keep going n shine like a diamond. 💖
Thank you for your comment 💗, it means a lot to me!