Excel VLOOKUP function

Function              VLOOKUP

Description        Excel VLOOKUP function to look up and retrieve data from a specific column in array

Syntax  VLOOKUP(value, table, column_index, [range_lookup])

value  The value to be looked up.

table  The table is the array from which to retrieve data.

column_index  The column number from which to retrieve data.

range_lookup  [optional] gives two options, exact match or approximate match. Default = TRUE = approximate match.

Click here to see posts related to function VLOOKUP

Related Video Tutorials: