Vlookup

What is VLOOKUP?

VLOOKUP stands for "Vertical Lookup." It’s a powerful function in Excel used to search for a value in the first column of a table and return a value in the same row from a specified column. 

=VLOOKUP(lookup_value, table array, col_index_num, [range_lookup]) 

lookup_value: The value you want to search for in the first column of the table.

table_array: The range of cells that contains the data you want to retrieve.

col_index_num: The column number in the table from which to retrieve the value.

[range_lookup]: An optional argument that specifies whether you want an exact match (FALSE) or an approximate match (TRUE). If omitted, Excel defaults to TRUE.

• range: The range of cells that you want to apply the criteria to.

• criteria: The condition or criteria that define which cells to sum. This can be a number, text, expression, or even a cell reference.

• [sum_range]: (Optional) The actual cells to sum. If omitted, Excel sums the cells in the range.