I’m trying to check for multiple values using the FILTER function. Here is my code:
=FILTER(Projects!$A$2:$P$51,Projects!$E$2:$E$51="Completed")
I would like to check for additional values besides Completed. Like, Canceled, or Review.
Additionally, if I could check for a portion of case-insensitive text like, "rev" that could help too.
>Solution :
Use ISNUMBER(MATCH(...))
=FILTER(Projects!$A$2:$P$51,ISNUMBER(MATCH("*"&Projects!$E$2:$E$51&"*",{"Completed","Canceled","Review"},0)))