Forum Discussion
IFS(OR(ISNUMER(SEARCH( function
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 :-/
Hm, this still doesn't solve my original problem. I need the function to produce a certain category. And that category depends on which word the function finds. So if F619 contains a word from Sheet2!$A$2:$A$10 it should produce Sheet2!$B$2 and when F619 contains a word from Sheet2!$A$11:$A$20 it should produce Sheet2!$B$11.
I thought of:
IFS(ISNUMBER(SEARCH(Sheet2!$A$2:$A$10,F619)),Sheet2!$B$2,ISNUMBER(SEARCH(Sheet2!$A$11:$A$20,F619)),Sheet2!$B$11)
But that one doesnt work for some reason. It gives #N/A except for Sheet2!$A$2, then it produces Sheet2!$B$2 like it should.