VLOOKUP Function

This article explains how to use the VLOOKUP function

VLOOKUP is a function to look up a value in a datasheet that is organized vertically. VLOOKUP supports approximate and exact matching. Lookup values must appear in the first column of the datasheet passed into VLOOKUP.

Demo

Syntax

FS
VLOOKUP (value, datasheet, col_index, [range_lookup])
  • value - The value to look for in the first column of a datasheet.
  • datasheet - The table from which to retrieve a value.
  • col_index - The column in the datasheet from which to retrieve the value you are looking for.
  • range_lookup - [optional] 0 = exact match (default). 1 = approximate match.
  • range_lookup_higher_bound - [optional] 0 = return lower value (default). 1 = return higher value

Sample Usage

Lookup the exact value of Question A in column 1 of Datasheet A and retrieve the value from the 2nd column (column numbering starts at 0 - zero):

FS
VLOOKUP(QA, DA, 1, 0)

OR

Lookup the value 135 in column 1 of Datasheet A and retrieve the value from the 3rd column:

FS
VLOOKUP(135, DB, 2, 1)

Example calculator

Notes

  • Instead of a table range in a spreadsheet program (e.g. A1:B22), the value of the datasheet needs to be just the reference to that datasheet (eg. formulascript>DA).
  • Instead of working with the native datasheet for tables you can also work with data from a Google Sheet. See this article to learn more.
  • Column numbering in a datasheet starts at 0. So if you need to retrieve a value in the 3rd column of your datasheet, you should reference this column in your formula with a 2.
ConvertCalculator Icon