LookupRows
Overview
Retrieves a rowset from a data extension where the field matches the specified value. You can specify additional field value pairs as part of an AND clause. This function returns a maximum of 2000 rows. To better control the number or the order of returned rows, use the LookupOrderedRows() function. This limitation helps enhance script performance.
Syntax
LookupRows(1, 2, 3)
Function Properties
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension |
| 2 | string | Required | Name of column from which to retrieve value |
| 3 | string or array | Required | Value used to match column value |