I’d like to return a description column value when the values of 2 other columns in that row match the values I set earlier in the code with
set @value1 = “X” and
set @value2 = “Y”
set @model = "ABC" set @offer_value = "XYZ" set @offer = Lookup("OfferLookup","description","offer",@offer_value)
but then also make sure it matches the column model with the value I set for model.
So return the value in the column "description" only when the "offer" column has "XYZ" AND the "model" column has "ABC".
Is the Lookup function what I should be using for this type of value return, or is this even possible?