Question 1 of 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | COUNTRY | CAPITAL | POPULATION | |
| 2 | France | Paris | 67000000 | |
| 3 | Germany | Berlin | 83000000 | |
| 4 | Italy | Rome | 59000000 | |
| 5 | Spain | Madrid | 47000000 | |
| 6 | Portugal | Lisbon | 10000000 | |
| 7 | Belgium | Brussels | 11500000 | |
| 8 | Netherlands | Amsterdam | 17500000 |
More VLOOKUP Practice - Free Excel Practice Online
This free, interactive exercise teaches you More VLOOKUP Practice 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 More VLOOKUP Practice 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 More VLOOKUP Practice lesson
- Use VLOOKUP to find France's capital.
- Use VLOOKUP to find Japan's currency.
- Use VLOOKUP to find Brazil's population.
- Use VLOOKUP to find the capital of the country in cell E2 (use the cell reference rather than text in your VLOOKUP).
- Use VLOOKUP to find Germany's continent using the range B:D.
- Use VLOOKUP to find the population tier for the value in cell E2 (using the cell reference) using approximate match. The fourth argument should be TRUE.
- Use VLOOKUP to return a country's currency for the value in cell E2.
- Use VLOOKUP to find the capital of Finland using the range A2:B8.
- Use VLOOKUP to return GDP of the country in cell E2.
- Use VLOOKUP to classify a country by land area using the value in E2 using approximate match.
More VLOOKUP Practice practice - FAQ
How do I practice More VLOOKUP Practice 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 More VLOOKUP Practice 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 More VLOOKUP Practice lesson?
This lesson covers More VLOOKUP Practice as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.