Hi,
I am trying to iterate each value in the "Address" column from my table 1 to the "Country" column in the table 2 and create a new column in the table 1 as "Match Found - YES/NO"
Table 1 | |
Address | Match Found? |
7th Street, DE | No |
P.O. Box 283 Fuse Rd. | No |
722 Dictum Av. US | YES |
P.O. Box 887 2508 Dolor. Av. US | YES |
5037 Diam street SA | YES |
Table 2 |
Country |
US |
SA |
DA |
IN |
PL, DE |
Solved! Go to Solution.
@prathap2020
Something like this?
christine_assaad It's working🙂. Thank you so much for your resolution.