Use VLOOKUP when you need to find things in a table or a range by row.
For example, find an employee’s name based on his employee ID.
In its simplest form, the VLOOKUP function says:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: What you want to look up.
- table_array: where you want to look for it.
- col_index_num: the column number in the range containing the value to return.
- [range_lookup]: return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Example
Find an employee’s name based on his employee ID
- Type “=VLOOKUP(”
- Click “fx” in the formula bar.
- In “lookup_value”, select cell E2
- In “table_array”, select the range from A1 to B8
- In “col_index_num”, Type “2”
- In “[range_lookup]“, Type “false” or “0”.
- Click on “OK”