Choose the cell where you want to apply the Vlookup formula
Vlookup Formula Syntax:
=VLOOKUP(search_key, range, index, \[is_sorted\])
2
**Vlookup**\
Type "=vlookup" and select the "Vertical lookup" option from the drop-down menu
3
**Search_Key**
Select the value to look for in the first column of the range
4
**Range**
Select the range of the data table. In this case, the information of the table is written from the cell B4 all the way to the cell D8)
5
**Index**
The number of the column within the specified range that contains the return value. It must be a positive integer.
In this case, we want to take the information from the third column of our table, hence, we type "3"
6
**\[is_sorted\]**
Type "FALSE" to ensure an exact match (recommended) or "TRUE" for an approximate match (this is the default if is_sorted is unspecified)
7
Once the formula is ready, complete it by using a closing parenthesis
8
Press "enter" and review the results of your vlookup