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. |
Thanks for your feedback!