LookupRows
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 the data extension. |
| 2 | string or array | Required | Name of the column to match for the row containing lookup value. You can also include an array of column names for use in a filter. |
| 3 | string or array | Required | String value used to match the lookup value. You can also include an array of column values for use in a filter. |