Retrieves the value of a specific field from a column in the specified data extension.


LookupOrderedRows(1, 2, 3, 4, 5)

Function Properties

1stringRequiredName of data extension from which you want to return specified rows
2numericRequiredNumber of rows to return. A value less than 1 returns the default 2000 rows. This limitation enhances script performance.
3stringRequiredIndicates how to order returned rows, including the value and ASC or DESC
4stringRequiredField to use to build WHERE clause.
5stringRequiredValue to use to build WHERE clause.