Exclude data conflicts and then match remaining Data

Originally Posted by jindon

In the case above, how would be the output for that row?

And one more,
Say if
STATE/TERRITORY EXCLUSIONS = NSW
SITE EXCLUSIONS = None
SITE PREFERENCES =1143(VIC)
When something like this happens, it still need to exclude 1143?.
I mean exclude all the states in STATE_TABLE?

The output can just show the SITE_ID of the match in Column 'BM', if there is no match the output can just say "No Match" - basically the end product will be a full list of USER_ID and Matched SITE_ID = e.g. 31267 and 422

For:
STATE/TERRITORY EXCLUSIONS = NSW
SITE EXCLUSIONS = None
SITE PREFERENCES =1143(VIC)
It would only Exclude sites in NSW, so 1143(VIC) would a correct match

I have attached a Picture that might help