Description
Searches a column for a given value, if found returns the (1 based) row index of the (first) matched value
Syntax
LookupList(<stringtofind>, <columntosearch>, <casesensitive>)
Arguments
Argument | Type | Description | Optional |
---|---|---|---|
stringtofind | String | Specifies a text value to search for in columntosearch | No |
columntosearch | Column Reference | Specifies a column to search | No |
casesensitive | Yes/No | Specifies whether a case sensitive search should be performed | Yes |
Returns
A number indicating the row number of the first match. If no match is found, Zero is returned.
Examples
Expression: | LookupList(BookTitle, [Lookups].[BookTitles].[Title], 0) |
Returns: | 312 |