VLOOKUP Function in Excel: Syntax, Examples and Free Practice
VLOOKUP is an Excel Lookup & Reference function. Looks up a value in the first column of a range and returns a value from another column, same row.
VLOOKUP syntax
Arguments
lookup_value: Value to search fortable_array: Range containing the datacol_index_num: Column to pull the result fromrange_lookup: FALSE for exact match
When to use VLOOKUP
Pulling an employee's salary into another sheet using their ID.
Practice VLOOKUP online, free
Solve graded VLOOKUP practice questions in a live Excel-style spreadsheet and check your answer instantly.
Practice VLOOKUP now →Learn more
Read the tutorial: How to use VLOOKUP in Excel.
VLOOKUP practice questions
- Using VLOOKUP, find the price of the product code typed in E2 and put it in F2.
- Find the department of the employee ID typed in E2 and put it in F2.
- Using VLOOKUP, find the marks of the roll number typed in E2 and put them in F2.
- Using VLOOKUP with approximate match, find each student's grade from the band table in…
- Customer ID is typed in F1. Find that customer's name and city and put them in F2 and F3.
- Using VLOOKUP, fetch the unit price for each ordered product from the price list in…
- Find the total amount for each order (quantity times the unit price from the price list…
- Using VLOOKUP with MATCH to pick the column automatically, find the units for the…
- Using VLOOKUP with a wildcard, find the price of the first laptop in the list whose name…
- Find the new salary after a 10% hike for the employee name typed in E2 and put it in F2.
- Orders are in A2:B7 and the price list is in D2:E6. Find the unit price for each order…
- Sales are in B2:B7 and the commission slabs in D2:E5 (a slab starts at the amount in…
- Employees to pay a bonus are in A2:A6 and the salary table is in C2:D6. Calculate each…
More Lookup & Reference functions
Frequently asked questions
What does the VLOOKUP function do in Excel?
Looks up a value in the first column of a range and returns a value from another column, same row.
What is the syntax of VLOOKUP in Excel?
The syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). lookup_value: Value to search for; table_array: Range containing the data; col_index_num: Column to pull the result from; range_lookup: FALSE for exact match.
Where can I practice VLOOKUP online for free?
Open the free live spreadsheet on Cellgrids and try VLOOKUP yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts