How to make a search formula for two text samples in a Google spreadsheet?

Question

Google Sheets

I need to get an answer whether there is text "7777" or text "9999" in text cell D5.
If the task was to get an answer about only one sample of text, I would use the formula
=SEARCHB(7777;D5)
But how to make a formula with two samples?
Thanks in advance.

Answer 1

Use regular expressions for complex string operations.
For one cell
=REGEXMATCH(T(A1),"7777|9999")
For a range
=ARRAYFORMULA(REGEXMATCH(T(A1:A12),"7777|9999"))
If it is known in advance that only text is in the range, then the formula T()can be omitted.
Example How to make a two-way search formula in a Google spreadsheet...
Regular expression test (link)

Answer 2

Or at least tell me how to use a formula to calculate that there is a number in one of the columns, while in one of the columns the result is "#VALUE!"