Returns the first value of a specified column from the row specified by a row key, from a DataCache specified by the DataCacheName.
@LookupValue(<DataCacheName>, <Value>, <ColumnNumber>, [<KeyColumnNumber>], [<MatchType>], [<Trim>])
| Argument Name | Description |
|---|---|
| ColumnNumber | The number of the column in the dataset to return if there is a match. |
| DataCacheName | The name of the data-cache to search. |
| KeyColumnNumber | Optional (default is 1); The column to inspect for the match. |
| MatchType | Optional (default is Exact); Valid values are Exact, Contains, StartsWith, and EndsWith. |
| Trim | Optional (default is TRUE); If TRUE the result will have trailing spaces removed. |
| Value | The value to search for. |