Hi all
I have these two formulas which work but I need to combine into one formula. I tried a few things but unsuccessful and given up. I could create helper columns but rather use single formula.
=IF($A11="","",IFERROR(IF(INDEX(PDA!$B$2:$B$1048576,MATCH(TRUE,ISNUMBER(SEARCH("*"&"Code Red"&"*",PDA!$Q$2:$Q$1048576)*SEARCH($A11,PDA!$B$2:$B$1048576)),0))=TRUE,"N","Y"),""))
=IF($A11="","",IFERROR(IF(INDEX(RDA!$B$2:$B$1048576,MATCH(TRUE,ISNUMBER(SEARCH("*"&"Code Red"&"*",RDA!$U$2:$U$1048576)*SEARCH($A11,RDA!$B$2:$B$1048576)),0))=TRUE,"N","Y"),""))
I need to combine them. Can someone help combine them please into one formula.

I have these two formulas which work but I need to combine into one formula. I tried a few things but unsuccessful and given up. I could create helper columns but rather use single formula.
=IF($A11="","",IFERROR(IF(INDEX(PDA!$B$2:$B$1048576,MATCH(TRUE,ISNUMBER(SEARCH("*"&"Code Red"&"*",PDA!$Q$2:$Q$1048576)*SEARCH($A11,PDA!$B$2:$B$1048576)),0))=TRUE,"N","Y"),""))
=IF($A11="","",IFERROR(IF(INDEX(RDA!$B$2:$B$1048576,MATCH(TRUE,ISNUMBER(SEARCH("*"&"Code Red"&"*",RDA!$U$2:$U$1048576)*SEARCH($A11,RDA!$B$2:$B$1048576)),0))=TRUE,"N","Y"),""))
I need to combine them. Can someone help combine them please into one formula.

