- Applies to: Excel for Office 365, Excel 2019, Excel 2016.
This blog post includes a VLOOKUP video tutorial which will help you to use VLOOKUP when you have to capture specific data in a table or range by row.
- Firstly, pick a cell.
- Secondly, enter =VLOOKUP( and then choose the value to lookup.
- Next, write a comma (,) and click the range or table to look for the value.
- Fourthly, enter a comma (,) and the number of the column where the lookup value is based.
- Furthermore, enter ,FALSE) to find an exact match.
- Finally, tap Enter.
VLOOKUP formula for the video example
The formula for the video example is the following:
=VLOOKUP(A7, A2:B5, 2, FALSE).
A breakdown of the VLOOKUP function
In its most basic form, the VLOOKUP function confirms:
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).
Need more help?
Refer to the listed resources below for any further questions you have about this VLOOKUP video tutorial and/or make a suggestion for a new tool or development to Excel.
- You can always ask an expert in the Excel Tech Community;
- Get support in the Answers community; or
- Suggest a new feature or improvement on Excel User Voice.