VLOOKUP

Use VLOOKUP for locating specific data, by row, within a table.

1. Choose a cell.
2. Type =VLOOKUP( and then click the value to lookup.
3. Enter a comma (,) and highlight the range or table to find the value.
4. Type a comma (,) and the digit of the column where the lookup value is found.
5. Type ,FALSE) to find a precise match.
6. 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).