Using VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. For example, find an employee email based on their employee name.
VLOOKUP Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Arguments
1. Lookup_value → The value you want to find. Example: Email
LookUp Function2. Table_array → The range of cells that contains the data.
(Important: the lookup_value must be in the first column of this range.)
Table Array
3. Col_index_num → The column number in the table array from which to return the value.
(1 = first column, 2 = second column, etc.)
Column Index
4. [Range_Lookup] → Tells Excel how to match.
- TRUE (or left blank): Approximate match (finds closest value).
- FALSE: Exact match (finds only exact value).
Range Lookup
5. Press Enter. 
Enter