Index Match with multiple ranges and criteria issue

[petrutms]

Hi there,
I have an issue with a formula, spent hours trying to make it work.
I have this formula working fine: =IF(IFERROR(INDEX(Home!$F$3:$F$14,MATCH([@TIP],Home!$G$3:$G$14,0)),FALSE),"No","Yes")
And i want to add this new range to it: (Home!$I$3:IF$17,MATCH([@DAS],Home!$J$3:$J$17,0)),FALSE)
The result should give YES or NO, based on afy of those 2 ranages and criteria...

Thank you for help!

 

[Eric W]

Welcome to the forum!

I appears your formula just says "Yes" if the value is not found, and "No, if it is found. If that's true, you can do without the INDEX part, and just go with something like this:

=IF(COUNTIF(Home!$G$3:$G$14,[@TIP])+COUNTIF(Home!$J$3:$J$14,[@DAS]),"No","Yes")

If not, please explain in words what you're trying to achieve.

 

[petrutms]

Hi, thanks for your reply. It doesnt work in this form. Please see the structure in image.
The formula should work like this:
If i check any cell from F or I columns, return NO in the corresponding filed from other sheet. Return YES if the cell is not checked.
I use this to filter some data in other sheet, the yes/no will populate a column in other sheet.
As i said this formula works fine with just in filter, i want to add other filter!

=IF(IFERROR(INDEX[B](Home!$F$3:$F$14,MATCH([@TIP],Home!$G$3:$G$14,0)),FALSE)[/B],"No","Yes")