Course Content
Excel Formulas
Excel Formulas
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_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. |
Everything was clear?