Is there a way to use multiple criteria when using the lookuprows ampscript function?
Example (which SFMC gives an error in that I can’t use the same column twice):
%%[
set @Category = "News"
set @Category2 = "Events"
set @rows = LookupRows("Content","Category", @Category,"Category", @Category2)
]%%
My work around is doing two Lookuprows with two FOR Loops which feels extremely inefficient.