Lookup

Overview

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

Syntax

Lookup(1, 2, 3, 4)

Function Properties

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

Example

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.