Searches for a value in one column of a table, and then returns a value in the same row from another column.
By default the table must be sorted in an ascending order.
If row or column does not exist, pad with zero or blank.
If only one key specified, select from the dimension that has multiple items.
If the lookup keys are all positive, a first row of zero will be appended to the datatable.
A numeric lookup key of zero will always return zero.
No zero append will occur if negative keys exist.
'DivScore' vlookup 1.5 'EUS' 'DIVSCORE'
'TableArray' vlookup LookupValue 'IndexColumn' 'ResultColumn' (RangeLookup)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| TableArray | Text | Field, Constant | Name of User | No |
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| LookupValue | Text | Field, Constant | Lookup value | No | |
| IndexColumn | Text | Field, Constant | Index Column | No | |
| ResultColumn | Text | Field, Constant | Result Column | No | |
| RangeLookup | Boolean | Field, Constant | Yes |
Type: Text
Interpolated value from result column