Advertisements

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).

Advertisements
%d bloggers like this: