Use VLOOKUP for locating specific data, by row, within a table.
- Choose a cell.
- Type =VLOOKUP( and then click the value to lookup.
- Enter a comma (,) and highlight the range or table to find the value.
- Type a comma (,) and the digit of the column where the lookup value is found.
- Type ,FALSE) to find a precise match.
- Hit Enter.
In its most basic form, the VLOOKUP function says:
=VLOOKUP(lookup value, range including the lookup value, the column number in the range encompassing the return value, optionally specify TRUE for estimated match or FALSE for a precise match).