SEARCH + OR Function Excel

Hello,

the simplest way would be to send an excerpt of your file on cjoint.com and post the link here.

See you later

pépé

I can't access cjoin.com due to company restrictions.

Actually, I would like to know how to search for multiple elements using the SEARCH function without having to type this function multiple times.

Thank you,

Fabien

Hello
I believe that your formula cannot work due to the lack of expressions in the conditions. Additions without conditions don't correspond to anything, in my opinion.
Try instead:

=IF(AND(ISNUMBER(SEARCH(26,C:C))*1;ISNUMBER(SEARCH(27,C:C))*1;ISNUMBER(SEARCH(28,C:C))*1;ISNUMBER(SEARCH(32,C:C))*1;ISNUMBER(SEARCH(35,C:C))*1;ISNUMBER(SEARCH(39,C:C))*1);5;0)
Pay attention to the parentheses and semicolons in the right places

I don't know what you're looking for, but this formula will return 5 IF ALL THE ISNUMBER items are verified
Kind regards
Let's ask ourselves if we are not the only ones to understand what is being explained?

Hello,
In 2003 try:
=IF(SUMPRODUCT((ISNUMBER(SEARCH(26,A1:A1000))*1+ISNUMBER(SEARCH(27,A1:A1000))*1+ISNUMBER(SEARCH(28,A1:A1000))*1+ISNUMBER(SEARCH(32,A1:A1000))*1+ISNUMBER(SEARCH(35,A1:A1000))*1+ISNUMBER(SEARCH(39,A1:A1000))*1))>=1,5,0)
It seems to work, but it doesn’t simplify things.
Moreover, Sumproduct requires limiting the ranges: A1:A1000, not the entire column A:A.

You should have said it right away!!!!!!!! :-(
You won't succeed like this, at least I think, in 2003 because at that time, Excel's IF code didn't accept more than 7 conditions and each of your items is one!

We might be able to find something if you tell us what's in column C and without leaving anything out this time!!

Let's ask ourselves if we're not the only ones who understand what we're explaining?

Here is the file:

Note that column C contains risk phrases and that these risk phrases correspond to a certain danger class in column D.

Thank you in advance.

http://cjoint.com/?0DutboAqVsr

Well seen the file, but sorry, I'll leave it to someone better to propose something, because in 2003 I don't see an immediate solution. At least not without modifying the organization of your data or creating complex intermediaries..

(unless the night brings advice, but I doubt it)

But that is within the limits of my skills and there are people on this forum who are much better, who will probably come to your aid.

As a side note and for your information, if it can help you:
the value 45 is repeated twice for two different evaluations in your formula, (for level 4 and for level 3).
Given how your items are organized, it is likely that in this case only the 4 will come out?

Best regards

--
Let's ask ourselves if we are not the only ones who understand what we are explaining?

Is there no solution?

Thank you Eric, indeed if I use {}, I can considerably simplify the formula.