VLOOKUP Function

VLOOKUP is a function used 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

• 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):

OR

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

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 (e.g., 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.