Combine two index match formulas into single formula

[dejamls]

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.

 

[Fluff]

Thanks for that.
How about

=IF($A11="","",IF(OR(IFERROR(ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH("Code Red",PDA!$Q$2:$Q$1048576)*SEARCH($A11,PDA!$B$2:$B$1048576)),0)),""),IFERROR(ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH("Code Red",RDA!$U$2:$U$1048576)*SEARCH($A11,RDA!$B$2:$B$1048576)),0)),"")),"Y","N"))

 

[dejamls]

Thanks Fluff. Works a treat, very much appreciatted.

 

[Fluff]

You're welcome & thanks for the feedback.