Hi folks,
I'm working with a spreadsheet where in A1 I have a variable length text string.
I also have an array of single text characters in eg. A2:Y2 (variable length array some cells may be "").
eg.
A1 = "hrsgo isduf gi"
A2 = "a"
B2 = "c"
function will return "TRUE", but if "g" is in C2 it'll return FALSE....
I need to find out if the string in A1 contains any of the characters in A2:Y2.
I could do this by doing 25 nested IFs with a formula like...
"=IF(NOT(ISERROR(FIND(A2,A1))),TRUE,FALSE)"
... but there's gotta be an easier way. Is it possible to use an array as the Find_Text input to the FIND() function? Or is there another way to do this?
Please keep it simple or give me an idiots guide to the answer as I'm self taught on this sort of stuff. I hope the explanation above makes sense to you....
Thanks for any help Paddy.
Bookmarks