0

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.

1
2

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.