Lookup
Retrieves the value of a specific field from a column in the specified data extension.
Lookup(1, 2, 3, 4)
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.