'Google Sheets Filter: OR not working on match functions
I have been working with the filter function in google sheets for a few months now and really like them, they're very powerful. Now recently, I wanted to try using the match function inside the filter function to find intersects between lists.
This I'm having some trouble with though, below is part of a filter function I'm trying to make but it doesn't seem to be working. Separately the match functions work fine in the filter but strung together with an OR (+) it doesn't work. It only returns the first match's results if that row's value also has true in the C column.
This might not be super clear, but maybe some of you have seen this before.
Here is an Example Sheet
=FILTER($C$6:$E,
(
MATCH($C$6:$C, FILTER('Other Tab'!$A$3:$A, 'Other Tab'!$B$3:$B), false) +
MATCH($C$6:$C, FILTER('Other Tab'!$A$3:$A, 'Other Tab'!$C$3:$C), false)
)
)
I tried stripping away most of the filter function except for the troubling part (the example I posted above).
I tried putting the other match first.
I tried mixing the match functions with other conditions and this combination is the only one giving me so much trouble.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
