AMPScript Lookup() with multiple criteria

Question

Haven't been able to dig up any mentions of this anywhere, but is there a way to use multiple criteria when using the lookup() AMPScript function?

Example:

%%=lookup(DE_name,ValueColumn,language,"FR",country,"CA")=%%

In this case, it would return the value from the desired column where language and country columns are equal to FR and CA respectively.

As @Jerry said... Yes you can. Below is documentation for any other questions you may have. help.exacttarget.com/en/documentation/exacttarget/content/… — DigitalMC, Commented Jul 23, 2015 at 12:33

Jerry · Accepted Answer · 2015-07-23 02:32:49Z

3

Probably should have just tried this out before posting, but just tested the above.

Looks like you can continue to add criteria pairs to lookup() and it seems to pull back records correctly.

answered Jul 23, 2015 at 2:32

Jerry

531 silver badge6 bronze badges

Add a comment |

1 Answer 1