Question 1 of 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Year | ||
| 2 | Ike | 2008 | ||
| 3 | Sandy | 2012 | ||
| 4 | Harvey | 2017 | ||
| 5 |
You are typing into D5. Refer to the cells that hold the data.
VLOOKUP Function - Free Excel Practice Online
VLOOKUP finds a value in the first column of a list and returns the matching value from a column to its right. This exercise explains that idea in three short steps, then has you type the formula yourself in a live grid: the year of a RAV4, the tenant in unit 254, the student who scored 95, Patrick's major, and the category of hurricane Sandy.
The examples end in 0, which asks for an exact match. The steps hand you a different range each time (A:B, B:C and A:C), so you see for yourself that the column number counts from the first column of the range, not from column A of the sheet. That is the step that trips up many beginners.
What you'll practice in this VLOOKUP Function lesson
- VLOOKUP, or Vertical Lookup, finds a value in a vertical list and returns the corresponding value in an adjacent vertical list. Get the year of hurricane Ike by typing this formula into the field below: =VLOOKUP("Ike", A1:B4, 2, 0)
- The first argument (values separated by commas) is the match value (what VLOOKUP looks for first). The second argument is the search area, and VLOOKUP looks for the match value only in its first column. The third argument is how many columns to the right the lookup will search (including the current column). Find the year of hurricane Sandy with: =VLOOKUP("Sandy", A1:D4, 4, 0)
- The final argument, 0, just means that you're looking for an exact match, rather than an approximate match. Don't worry about this for now; it'll be 0 in most cases. Find the MAKE of the Impala using a VLOOKUP formula.
- Find the YEAR of the RAV4 using vlookup
- Use VLOOKUP to find the name of the tenant in unit number 254. Use A:B as your second argument to include all of columns A and B in your search range.
- Using the A:B range, use VLOOKUP to find the name of the student who scored 95 on the test
- Using the B:C range, use VLOOKUP to find Patrick's major
- Using the A:C range, use VLOOKUP to get the category of hurricane Sandy
- Using the B:C range, use VLOOKUP to get the category of the hurricane that happened in 2017
- Using the A:B range, use VLOOKUP to get the year of hurricane Bob
VLOOKUP Function practice - FAQ
How do I practice VLOOKUP Function in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the VLOOKUP Function exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this VLOOKUP Function lesson?
This lesson covers VLOOKUP Function as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.
Why does the last argument in these VLOOKUP exercises have to be 0?
A 0 (or FALSE) as the fourth argument asks VLOOKUP for an exact match. Leave it out and Excel assumes an approximate match, which only works on sorted data and can return a wrong row without any warning. This lesson uses 0 throughout.