{"id":31460,"date":"2018-04-21T15:47:47","date_gmt":"2018-04-21T15:47:47","guid":{"rendered":"https:\/\/ampscript.guide\/lookup\/"},"modified":"2025-01-10T15:15:34","modified_gmt":"2025-01-10T15:15:34","slug":"lookup","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/lookup\/","title":{"rendered":"Lookup"},"content":{"rendered":"

Lookup<\/h2>\n

This function returns the value of a single column from a Data Extension.<\/p>\n

Arguments<\/h3>\n

Lookup(1,2,3,4,[5a,5b]...)<\/code><\/p>\n\n\n\n\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nName of the Data Extension from which to return a value<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nName of the column from which to return a value<\/td>\n<\/tr>\n
3<\/td>\nString<\/td>\nTrue<\/td>\nName of the column that identifies the row to retrieve<\/td>\n<\/tr>\n
4<\/td>\nString<\/td>\nTrue<\/td>\nValue that identifies the row to retrieve<\/td>\n<\/tr>\n
5a<\/td>\nString<\/td>\nFalse<\/td>\nAdditional column name that identifies the row to retrieve (see note)<\/td>\n<\/tr>\n
5b<\/td>\nString<\/td>\nFalse<\/td>\nAdditional value that identifies the row to retrieve (see note)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: Additional pairs of columns and values can be appended as arguments.<\/p>\n

NOTE: If the specified name and value pair criteria match more than one row in the Data Extension, a single value is still returned. The row chosen for the return value cannot be specified and should be not considered consistent.<\/p>\n<\/blockquote>\n

Example 1<\/h3>\n

The following illustrates the use of this function with the minimum number of arguments.<\/p>\n

Data Extension<\/strong>: LoyaltyMembers<\/em><\/p>\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nData Type<\/th>\nLength<\/th>\nPrimary Key<\/th>\nNullable<\/th>\nDefault Value<\/th>\n<\/tr>\n<\/thead>\n
EmailAddress<\/td>\nEmailAddress<\/td>\n254<\/td>\nN<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
SubscriberKey<\/td>\nText<\/td>\n254<\/td>\nY<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
FirstName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
LastName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
Created<\/td>\nDate<\/td>\n<\/td>\nN<\/td>\nY<\/td>\nCurrent Date<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nLastName<\/th>\nCreated<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nSmith<\/td>\n2017-10-21 12:01<\/td>\n<\/tr>\n
suzy@limedash.com<\/td>\n5497<\/td>\nSuzy<\/td>\nJackson<\/td>\n2017-10-20 11:01<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nCameron<\/td>\n2017-10-19 10:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Here is an example utilizing the preceding context:<\/p>\n

%%[\n\nvar @EmailAddress, @lookupValue\n\nset @lookupValue = AttributeValue(\"_subscriberkey\") \/* value from attribute or DE column in send context *\/\nset @lookupValue = \"5497\" \/* or a literal value *\/\n\nset @EmailAddress = Lookup(\"LoyaltyMembers\",\"EmailAddress\",\"SubscriberKey\", @lookupValue)\n\n]%%\nEmailAddress: %%=v(@EmailAddress)=%%<\/code><\/pre>\n
Output<\/h4>\n
EmailAddress: suzy@limedash.com<\/code><\/pre>\n
Example 2<\/h3>\n
\n\n\n\t\n\t
\n\n\t\t\n\t\t