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.
LookupRows(1, 2, 3)
| 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. |