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

OrdinalTypeDescription
1stringRequiredName of data extension
2stringRequiredName of column from which to retrieve value
3string or arrayRequiredValue used to match column value

Examples