Hi all,
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!
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!