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.