AMPScript Lookup Examples

Here are a few ways to retrieve external data with AMPScript inside your email or landing page:

Lookup value of single column value from a certain row

Lookup multiple column values from a single row

Lookup multiple column values from multiple ordered rows

For further reference:
lookup
lookupRows
lookupOrderedRows
rowcount
row
field



Leave a Reply

3 Comments on "AMPScript Lookup Examples"

Notify of
avatar
Sort by:   newest | oldest | most voted
Vic
Guest

Hey Adam, I want to pull content from a data file (containing one row) that doesn’t have any common columns with the subscribers list. I cannot tie the 2 files together so I cannot use LookUp or LookUpRows. Is there a way to do still do it? Question posted here as well: http://salesforce.stackexchange.com/questions/139997/ampscript-pull-content-from-a-data-file-without-lookup

Javier
Guest

Hello, I cant access the data extension data with a lookup function if it is a shared data extenion

Adam Spriggs
Guest

Just add an “ent.” to the beginning of your Data Extension name.

wpDiscuz