VLOOKUP

• VLOOKUP is a Excel Function.
• Lookup is a value in a table by matching on the first column.
• It returns a matched value from a table.
Syntax
=VLOOKUP(value,table,col_index,[range_lookup])







Value: The value to look for in the first column of a table.
Table: The table from which to retrieve a value.
Col_index: The column in the table from which to retrieve a value.
Range_lookup: [optional]True = approximate match(default).FALSE = exact match.

• VLOOKUP searches for a value in the first column of a table.
• At the match row, it retrieves a value from the specified column.

Notes