Ok cool thanks,
for USER ID = 11111
STATE/TERRITORY EXCLUSIONS = VIC
SITE EXCLUSIONS = 1143(corresponding value in SITE_TABLE = VIC) at SITE_ID_4
SITE PREFERENCES = 717(corresponding value in SITE_TABLE = Blank) at SITE PREFERENCES

So their site preference of 717 doesn't have a State assigned - so in this case It would be "NO Match" and I would need to manually contact this person to discuss left over available sites after all of the Matches had been processed.

My main goal is to match as many People as possible, but where the data is not yet perfect, we will need to manually contact the person and manually match.

(The data is currently being updated and cleansed so I can run the algorithm multiple times as the data becomes better)