Excel VLOOKUP is a very useful function to retrieve data from table rows. We lookup function easily return the data in a table or a range by row. As example, to lookup the age of a person.
Excel VLOOKUP formula
Syntax : VLOOKUP (value, table, col_index, [range_lookup])
- Value : The value to search from first column of a table
- Table : Table range
- col_index : which column of the table to retrieve the data.
- range_lookup : False – Exact Match/True approximate match
The syntax can be summarized as as VLOOKUP(Value to look up, table range to lookup the value, table column number to return the value,FALSE/TRUE)
Example
`
- Value : C14 – the cell to write the Name
- Table :B3:E6 the range of the table from B2 until E6.
- col_index : 2 , the second column of the table.
- range_lookup : False – Exact Match
- Syntax : VLOOKUP(C14,B2:E6,2,FALSE)