VLookup

Description

The VLookup function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the indexNumber position.

Syntax

The syntax for the VLookup function in GoFormz is:

VLookup(value, range, indexNumber, [approximate_match])

Parameters or Arguments

value
The value to search for in the first column of the table.
range
Two or more columns of data that is sorted in ascending order.
indexNumber
The column number in table from which the matching value must be returned. The first column is 1.
approximate_match
Enter "false" to find an exact match. Entering "true" to find an approximate match is not supported at this time

Example

Set up a table with the following values

Order ID	Product	Unit Price	Quantity
10247	Apples	$14.00	12
10249	Oranges	$9.80	10
10250	Bananas	$34.80	5
10251	Pears	$18.60	9
12052	Grapes	$42.30	40

Example formulas:

Formula	Description	Result
=VLookup(10251, [Table]![1][1]:[2][5], 2, "false")	Returns value in 2nd column	Pears
=VLookup([Table]![1][3], [Table]![1][1]:[3][5], 3, "false")	Returns value in 3rd column	$34.80
=VLookup(10251, [Table]![1][1]:[4][5], 4, "false")	Returns value in 4th column	9
=VLookup(10248, [Table]![1][1]:[2][5], 2, "false")	Returns value in 2nd column (no exact match)	blank