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