Exclude data conflicts and then match remaining Data

Hi Jindon,

Thanks for your reply.

Apologies, I may have complicated it, I will try to explain it more simply:


A person (USERID) is going to provide me with a list of states that they can't work in, for Example NSW and QLD.
The person will also provide me with a list of Site ID's that they also can't work in (could be 0 to 50).
The person will then provide me with a list of Site ID's that they would like to work in (Could be 0 - 5)

That information will come in a single row.

My job will be to match the person with their preferred site from their list of preferences.

They can't be matched with a site that they say they can't work in, or a site from a state that they can't work in.

Any that don't match for any reason can say "No Match"

I only have 4 examples in the spreadsheet so far: UserID 11111, 15452,31267 and 24126. But if it helps I can import a full list of all UserID's.