# VLOOKUP Video Tutorial

• 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.

1. Firstly, pick a cell.
1. Secondly, enter =VLOOKUP( and then choose the value to lookup.
1. Next, write a comma (,) and click the range or table to look for the value.
1. Fourthly, enter a comma (,) and the number of the column where the lookup value is based.
1. Furthermore, enter ,FALSE) to find an exact match.
1. 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.