How can I get the search function to look through multiple columns?

=(FILTER(P1:Y500,search(F5(T1:T500) (U1:U500))))

=(FILTER(P1:Y500,search(F5(T1:T500 U1:U500))))

=(FILTER(P1:Y500,search(F5(T1:U,U1:U))))

=(FILTER(P1:Y500,search(F5,T1:U U1:U)))

These obviously don't work, but I can't figure it out. Any help would be much appreciated.

CodePudding user response：

try:

=FILTER(P1:Y500; REGEXMATCH(T1:T500&U1:U500; F5&""))