What do you know about VLOOKUP?

VLOOKUP is an Excel function that is used to lookup and retrieves data from a specific column in an excel table. VLOOKUP supports approximate and exact matching. In VLookup, the “V” stands for “vertical”. Also, the lookup values must appear in the first column of the table, with lookup columns to the right.

Purpose: Lookup a value in a table by matching on the first column

Return Value: Matched value from a table

Syntax: =VLOOKUP (lookup_value, table_array, col_index, [range_lookup])

This function is also called as ‘Vertical Lookup’ function where the formula performs a vertical search in the first column of the selected data table, then using index value provided in the formula it retrieves the result which is available in the same row.

  • Select ‘VLOOKUP’ function.
  • Lookup_value = Click on the cell for which you want to get the result.
  • Table_Array = Select all the data in columns.
  • Col_Index_num = the column number where the result exists.
  • Range_Lookup = Write ‘True’ or ‘1’ for approximate value. Similarly ‘False’ or ‘0’ for exact value.
  • Click on OK.