LookupOrderedRows

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

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

Ordinal	Type		Description
1	string	Required	Name of data extension from which you want to return specified rows
2	numeric	Required	Number of rows to return. A value less than 1 returns the default 2000 rows. This limitation enhances script performance.
3	string	Required	Indicates how to order returned rows, including the value and ASC or DESC
4	string	Required	Field to use to build WHERE clause.
5	string	Required	Value to use to build WHERE clause.