Question 1 of 10
1. The value you know
2. The range to search. VLOOKUP looks for the value you know only in the first column of this range
3. How many columns to look to the right
4. Whether to use approximate match (this will be false if looking for an exact match)
In the formula bar, use the following formula to find the banana production of Paraguay:
=VLOOKUP("Paraguay", A:B, 2, FALSE)
Enter the resulting number into the field below to check your answer.
VLOOKUP - Free Excel Practice Online
This free, interactive exercise teaches you VLOOKUP in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising VLOOKUP this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this VLOOKUP lesson
- The VLOOKUP function has 4 arguments: 1. The value you know 2. The range to search. VLOOKUP looks for the value you know only in the first column of this range 3. How many columns to look to the right 4. Whether to use approximate match (this will be false if looking for an exact match)In the formula bar, use the following formula to find the banana production of Paraguay: =VLOOKUP("Paraguay", A:B, 2, FALSE)Enter the resulting number into the field below to check your answer.
- Modify your formula to find the banana production of Solomon Islands. Copy the resulting number into the field below.
- Use VLOOKUP to find the number of tonnes of coffee beans produced by Ghana.
- You know a certain country produced 3,295 tonnes of bananas, but you don't know which country. Use VLOOKUP to find the number of tonnes of coffee beans that country produced.
- Use VLOOKUP to find the number of tonnes of coffee beans produced by Cambodia.
- Use VLOOKUP to find the number of tonnes of avocados produced by Kenya.
- Use VLOOKUP to find the number of tonnes of avocados produced by the country that produced 370 tonnes of coffee beans.
- Use VLOOKUP to find the number of tonnes of avocados produced by the country that produced 66,381 tonnes of bananas.
- Use VLOOKUP to find the number of tonnes of coffee beans produced by Belize.
- Use VLOOKUP to find the number of tonnes of coffee beans produced by Fiji.
VLOOKUP practice - FAQ
How do I practice VLOOKUP 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 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 lesson?
This lesson covers VLOOKUP as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.