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: