Summary  
This chapter covers the use of a lookup function that searches for a key in the first column of a table and retrieves the associated value from a specified column, with support for exact or approximate matching.

General domain of usage  
Spreadsheet data manipulation and analysis

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:

<div style="display: flex; justify-content: center;">=VLOOKUP(lookup_value,&nbsp;table_array,&nbsp;col_index_num,&nbsp;[range_lookup])</div>

| | |
|-----------------|----------------------------------------------------------------------------------------------------|
| lookup_value | The value to search for. |
| table_array | The table or range where data is looked up. |
| col_index_num | The 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?

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

Learn how to enter and use Excel formulas for calculations, including basic operations like addition, subtraction, multiplication, division, and exponentiation. Understand the importance of using functions to make your formulas clearer and more efficient.

Learn array formulas in Excel and how they enable multiple calculations on sets of values simultaneously. Explore how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


lookup_value	The value to search for.
table_array	The table or range where data is looked up.
col_index_num	The 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.

VLOOKUP

Awesome!

VLOOKUP