I’m trying to figure out to lookup values with “CONTAINS” statement and using multiple conditions.
Here are some examples:
Lookup table has the following values:
Col 1 Return Val
CINCINNATI CIN
COLUMBUS, OH CL1
COLUMBUS, GA CLGA
DENVER DN
Main table has the following columns:
City State
CINCINNATI OH
COLUMBUS GA
DENVER CA
The problem is that lookup table has optional state while it is always present in the main table, so I’m not sure how to perform correct lookup.
Thank you!