Hi all,
I'm trying to write an IF(ISNUMBER(SEARCH to search for one piece of text when it could possibly be in two cells, I understand that C41:D41 doesn't work but I can't see how to write it correctly. Any assistance gratefully received.
Hi all,
I'm trying to write an IF(ISNUMBER(SEARCH to search for one piece of text when it could possibly be in two cells, I understand that C41:D41 doesn't work but I can't see how to write it correctly. Any assistance gratefully received.
=IF(ISNUMBER(SEARCH("me",A1&B1,1)),TRUE,FALSE)
I think you mean if the string is in either cell, not concatenated cells as radulguy gives?
=IF(LOOKUP(62^13,SEARCH("Text",C41:D41)),"Found","Not Found")
Regards
@XOR LX
I believe our formulas are equivalent, i.e. it searches for the value "me" in the string "A1textB1text", so if either A1 or B1 contain me, it will return true.
But what if the string in A1 ends in "m" and that in B1 starts in "e"?
Regards
@XOR
True:
=IF(ISNUMBER(SEARCH("me",A1&"XXX"&B1,1)),TRUE,FALSE)
Can't argue with that! Nice alternative idea, by the way.
Sorry for the late reply. The original response did what I required...thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks