I'm using Google Sheets (only option, sorry, know this should be a database).
Sheet 1: List of 200 employee names, and up to 10 location codes they are frequently assigned to. Sheet 2: List of 50 organization, each with 9 location codes.
What I want to do is have a way of figuring out which employees could be sent to organization #22, based on if there is any overlap of them both being assigned the any of the same codes.
So, employee #189 might have codes: D123, D239, D873, D982, T893, T762, T874 And on the other sheet organization #22 has codes: D1, D2, D3, D120, D121, D123, T1, T2, T3
They should be a "match" because the employee has the code D123 - which is one of the parameters assigned to organization #22.
Is this possible??
Google spreadsheets will support some query functions but this is really beyond my normal usage.