I want to match 2 array columns in two different sheets with a relation and get only those matches which are a AND condition.
Example:
A sheet with people searching for houses, with an array column showing all of their search criteria.
A second sheet with house offerings with an array column showing all house criteria.
The result should be an array in the people sheet which shows only those houses which match all search criteria.
I searched different forum posts and looked at the video (Multiple Categories - Glide Library), but it seems that the match is always comparable to a OR condition, and showing houses which match only one two criteria and not all.
Has anybody an idea how to solve this?
Thank you