Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
VLOOKUP | Lookup and Reference
Excel Formulas
course content

Course Content

Excel Formulas

Excel Formulas

1. Basic Formulas
2. Array Formulas
3. Lookup and Reference

VLOOKUP

The VLOOKUP function (short for Vertical Lookup) is one of the most commonly used lookup functions in Excel. It allows you to search for a value in the leftmost column of a table or range, and then retrieve a value in the same row from a specified column. Here's how the syntax of VLOOKUP looks:

lookup_valueThe value to search for.
table_arrayThe table or range where data is looked up.
col_index_numThe column number in the table from which to retrieve the value.
[range_lookup](Optional). If TRUE or omitted, an approximate match is returned (default). If FALSE, an exact match is required.

What does the VLOOKUP function do in Excel?

Select the correct answer

Everything was clear?

Section 3. Chapter 4
We're sorry to hear that something went wrong. What happened?
some-alt