All the ranges must be the same size
Try
Earlier you asked about ISNUMBER()
SEARCH() & FIND() both return a number if the search string is found in the data string.
If the string isn't found a #VALUE! error is returned
So
=ISNUMBER(10) returns TRUE
=ISNUMBER(#VALUE!) returns FALSE
This can then be coerced to
=ISNUMBER(10)*1 returns 1
=ISNUMBER(#VALUE!)*1 returns 0
What and where are the extra conditions you need to apply?
There are many different ways to handle this, it all depends on what the conditions are.
Bookmarks