Use VLOOKUP when you need to find things in a table or range by row.
Select a cell.
Type =VLOOKUP( and then select the value to lookup.
Type a comma (,) and select the range or table to look for the value.
Type a comma (,) and the number of the column where the lookup value is located.
Type ,FALSE) to find an exact match.
The formula for the video example is as follows:
=VLOOKUP(A7, A2:B5, 2, FALSE).
In its simplest form, the VLOOKUP function says:
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for approximate match or FALSE for an exact match).