---
title: "VLOOKUP practice: 5 exercises with answers | ExcelSavvy"
description: "Practice VLOOKUP in Excel: exact and approximate match, a number key, bringing prices into an order list and fixing a lookup that fails on a space."
canonical_url: "https://excelsavvy.com/practice/vlookup"
meta:
  "og:description": "Practice VLOOKUP in Excel: exact and approximate match, a number key, bringing prices into an order list and fixing a lookup that fails on a space."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBwcmFjdGljZTogNSBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgVkxPT0tVUCBpbiBFeGNlbDogZXhhY3QgYW5kIGFwcHJveGltYXRlIG1hdGNoLCBhIG51bWJlciBrZXksIGJyaW5naW5nIHByaWNlcyBpbnRvIGFuIG9yZGVyIGxpc3QgYW5kIGZpeGluZyBhIGxvb2t1cCB0aGF0IGZhaWxzIG9uIGEgc3BhY2Uu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRyJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDb2RlIiwiUHJvZHVjdCIsIlByaWNlIiwiUHJpY2UiXX0seyJuIjoyLCJjZWxscyI6WyJBMTAiLCJQZW4iLCIxMiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkIyMCIsIk5vdGVib29rIiwiMzUiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJDMzAiLCJTdGFwbGVyIiwiODkiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJENDAiLCJGb2xkZXIiLCIyNCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS92bG9va3VwIg%2Cs_OVtixvUbY252W8VN.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "VLOOKUP practice: 5 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBwcmFjdGljZTogNSBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgVkxPT0tVUCBpbiBFeGNlbDogZXhhY3QgYW5kIGFwcHJveGltYXRlIG1hdGNoLCBhIG51bWJlciBrZXksIGJyaW5naW5nIHByaWNlcyBpbnRvIGFuIG9yZGVyIGxpc3QgYW5kIGZpeGluZyBhIGxvb2t1cCB0aGF0IGZhaWxzIG9uIGEgc3BhY2Uu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRyJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDb2RlIiwiUHJvZHVjdCIsIlByaWNlIiwiUHJpY2UiXX0seyJuIjoyLCJjZWxscyI6WyJBMTAiLCJQZW4iLCIxMiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkIyMCIsIk5vdGVib29rIiwiMzUiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJDMzAiLCJTdGFwbGVyIiwiODkiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJENDAiLCJGb2xkZXIiLCIyNCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS92bG9va3VwIg%2Cs_OVtixvUbY252W8VN.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **VLOOKUP practice exercises**

Look up a value in the first column of a table and return a value from another column, with an exact or approximate match.

[**Start the first exercise**](https://excelsavvy.com/practice/vlookup/vlookup-exact-match)

VLOOKUP(

## **How VLOOKUP works**

VLOOKUP finds a value in the first column of a table and returns the value from another column in the same row. It takes four arguments: what to look for, the table, which column to return (counting from the table's first column), and FALSE for an exact match.

`**=VLOOKUP(A2,$E$2:$G$50,3,FALSE)**` looks up the ID in A2 in the first column of E2:G50 and returns the third column. The dollar signs keep the table in place when you copy the formula down.

Most VLOOKUP mistakes are one of three things: leaving out FALSE, so Excel returns the nearest match instead of an exact one; a lookup value that is not in the first column of the table; and IDs stored as text in one place and as numbers in the other. The exercises below cover a price lookup, a number key, approximate match for bands, filling prices into an order list with a locked table, and a lookup that fails on a stray space.

1. [**1****Look up a price with VLOOKUP**In G2, use VLOOKUP to find the Price of the code in F2. Ask for an exact match.](https://excelsavvy.com/practice/vlookup/vlookup-exact-match)
2. [**2****VLOOKUP a number key****Premium**In G2, use VLOOKUP to return the Salary of the employee whose ID is in F2.](https://excelsavvy.com/practice/vlookup/vlookup-number-id)
3. [**3****VLOOKUP with an approximate match****Premium**In E2, find the commission rate for the sales in D2. The table lists where each band starts, so use VLOOKUP with TRUE for an approximate match.](https://excelsavvy.com/practice/vlookup/vlookup-approximate-match)
4. [**4****Bring prices into an order list****Premium**In C2, look up the price of the code in B2 in the price table E2:F5. Lock the table with $ so the formula can be filled down the order list: VLOOKUP(B2,$E$2:$F$5,2,FALSE).](https://excelsavvy.com/practice/vlookup/vlookup-fill-down-locked-table)
5. [**5****Fix a VLOOKUP that fails on a space****Premium**The code in F2 was pasted from an email and ends with a space, so a plain VLOOKUP returns #N/A. In G2, look up the price with TRIM(F2) as the lookup value.](https://excelsavvy.com/practice/vlookup/vlookup-trim-spaces)

## **Functions in this topic**

- [**VLOOKUP**](https://excelsavvy.com/functions/vlookup)

## **Read the guide**

- [**Excel test for a job interview: what it looks like and how to practice**](https://excelsavvy.com/learn/excel-for-job-interviews)
- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**](https://excelsavvy.com/learn/vlookup-vs-xlookup-vs-index-match)
- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**Excel practice data: free datasets with tasks and answers**](https://excelsavvy.com/learn/excel-practice-data)
- [**Best Excel courses online in 2026: 10 places to learn Excel, ranked**](https://excelsavvy.com/learn/best-places-to-learn-excel)
- [**Udemy vs Coursera vs LinkedIn Learning for Excel: which to pick**](https://excelsavvy.com/learn/udemy-vs-coursera-vs-linkedin-learning-excel)

## **Questions**

<details>

<summary>

### How do I use VLOOKUP with another sheet?

</summary>

Put the sheet name and an exclamation mark in front of the table: =VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE). If the sheet name has spaces, wrap it in single quotes, like 'Price List'!$A$2:$C$50. The lookup value stays on your current sheet, and only the table lives on the other one.

</details>

<details>

<summary>

### What is the difference between VLOOKUP and XLOOKUP?

</summary>

XLOOKUP looks in one range and returns from another, so it can look to the left, it does not break when you insert a column, and it matches exactly by default. VLOOKUP needs a column number and FALSE for an exact match. XLOOKUP needs Excel 365 or Excel 2021, so VLOOKUP is safer in files shared with older versions.

</details>

<details>

<summary>

### Why is VLOOKUP not working when the value is there?

</summary>

The two values look the same but are not. Remove stray spaces with TRIM(A2), and remove a non-breaking space from a web page with SUBSTITUTE(A2,CHAR(160),""). If a number is stored as text, convert it with VALUE(A2) or multiply it by 1, so both sides have the same type.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/vlookup#webpage","description":"Practice VLOOKUP in Excel: exact and approximate match, a number key, bringing prices into an order list and fixing a lookup that fails on a space.","name":"VLOOKUP practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/vlookup","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/vlookup#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/vlookup"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/vlookup#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"VLOOKUP practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I use VLOOKUP with another sheet?","acceptedAnswer":{"@type":"Answer","text":"Put the sheet name and an exclamation mark in front of the table: =VLOOKUP(A2,Prices!$A$2:$C$50,3,FALSE). If the sheet name has spaces, wrap it in single quotes, like 'Price List'!$A$2:$C$50. The lookup value stays on your current sheet, and only the table lives on the other one."}},{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is the difference between VLOOKUP and XLOOKUP?","acceptedAnswer":{"@type":"Answer","text":"XLOOKUP looks in one range and returns from another, so it can look to the left, it does not break when you insert a column, and it matches exactly by default. VLOOKUP needs a column number and FALSE for an exact match. XLOOKUP needs Excel 365 or Excel 2021, so VLOOKUP is safer in files shared with older versions."}},{"@id":"https://excelsavvy.com/practice/vlookup#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Why is VLOOKUP not working when the value is there?","acceptedAnswer":{"@type":"Answer","text":"The two values look the same but are not. Remove stray spaces with TRIM(A2), and remove a non-breaking space from a web page with SUBSTITUTE(A2,CHAR(160),\"\"). If a number is stored as text, convert it with VALUE(A2) or multiply it by 1, so both sides have the same type."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
