From what I've been able to find, this function only works when range1 and range 2 are the same size (i.e 1 column each in my case). This works great when my formula is this:

=IF(COUNTIFS('Current Order Numbers'!$B:$B,$A3,'Current Order Numbers'!$H:$H,"*"&BA2&"*")>0,"Y","N")

However, I now need to extend the range2 to look not just in column H, but in 3 columns, so I want to change my formula to:

=IF(COUNTIFS('Current Order Numbers'!$B:$B,$A3,'Current Order Numbers'!$H:$J,"*"&BA2&"*")>0,"Y","N")

Essentially, now looking for the value in BA2 to not just a wildcard search in column H, but also column I and column J.

This breaks the formula. What's my solution?

Thank you!