Hi Alessio, thank you for your reply.
Actually my problem is how to do the query/filter the other way around.
In a scenario where I have one known value, I can easily filter to show records with a cell contaaining many values. So ONE TO MANY ...it works.
My problem is I am trying to filter the other way around.
I have MANY options, and I want to filter cell (Single Select) to show me the match.
So basically MANY TO ONE doesn't seem to work in my case.