LookupRows

Overview

Returns a rowset from a data extension where the field matches the specified value. 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 enhances script performance.

Syntax

LookupRows(1, 2, 3)

Function Properties

OrdinalTypeDescription
1stringRequiredName of data extension from which to return specified rows
2stringRequiredColumn name used to identify rows to return
3stringRequiredValue used to match rows to return

Usage

Returns the ZipCode rows where the City field matches for HomeCity value.