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 |