Lookup

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

Syntax

Lookup(1, 2, 3, 4)

Function Properties

Ordinal	Type		Description
1	string	Required	Name of data extension
2	string	Required	Name of column from which to retrieve value
3	string or array	Required	String value with name to match for row containing lookup value. You can also include an array of column names for use in a filter.
4	string or array	Required	String value used to match lookup value. You can also include an array of column values for use in a filter.

The example returns the value in the Phone field from the CustomerData data extension for the row with the SubscriberKey value of acruz@example.com.

The example returns the value in the Phone field from the CustomerData data extension for the row with the FirstName value of Angela and the last name value of Cruz.