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.


LookupRows(1, 2, 3)

Function Properties

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


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