Forum Discussion
IFS(OR(ISNUMER(SEARCH( function
Are you testing to see if any of those words show up in F619?
How about creating a list of words to check and then using match as your logic..
Something like, =if(isnumber(match(F619,Sheet2!$A$2:$A$10,0)),True,False)
even better would be to make it a table or named range. This would also have the advantage of making it really easy to add/change/remove things to search for at a later date.
Yes, that's what I'm testing. I like the idea, but I have to find the words in a bigger line of text within F619.
Ah. Try this then..
=or(if(isnumber(search(Sheet2!A2:A10)),F619,True,False))
You need to enter it as an array ctrl+shift+enter..
I tried your formula a few times and tried to adjust some things but I can't get it to work. It says that I have provided too few arguments for this function.
Search needs a location where to search between the parentheses so on the dots: =or(if(isnumber(search(Sheet2!A2:A10;.......)),F619,True,False))
And where you put "False" shouldn't be anything because 'if(' needs only three values: logical test, value if true and value if false and you put four.
(I'm Dutch so some of the translations of "value if true" etc. can be a little bit off, but the functions are translated correctly)No its me, sorry..
=OR(IF(ISNUMBER(SEARCH(Sheet2!$A$2:$A$10,F619)),TRUE,FALSE))
the brackets were in the wrong place :-/