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

Example of the VLOOKUP formula explained.
Extend Office, 2020

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.

See Also

VLOOKUP function

Leave a Reply

%d bloggers like this: