Forum Discussion
How do I use text search and OR statements to check if a cell contains "2022" or "2021" or "2020"?
=IF(OR(ISNUMBER(SEARCH(I2,"2022")), ISNUMBER(SEARCH(I2,"2021")), ISNUMBER(SEARCH(I2,"2020"))),"y","n")
Not working, it always returns "n"
Change SEARCH(I2,"2022") to SEARCH("2022",I2) etc.
Slightly shorter:
=IF(OR(ISNUMBER(FIND({"2020","2021","2022"},I2))),"y","n")
