Lookup
Overview
Returns specified value from a data extension. You can specify multiple additional field and value pairs as part of an AND clause.
Syntax
Lookup(1, 2, 3, 4)
Function Properties
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension from which to return the specified value |
| 2 | string | Required | Name of column from which to return a value |
| 3 | string | Required | Name of column used to identify row containing lookup value |
| 4 | string | Required | Value to match string against |
Usage
Returns the city associated with the postal code 46016 in the PostalCode data extension: Anderson, IN