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 |
Updated 11 days ago