Formula to Find/Search more letters at once?

**zeko90** · 09-26-2014, 06:41 AM

Hi to all,

i have one question. I would like to search more letters at once from more cells. Is this possible?

Example:
If cell have next letter make number "1". (search for next letters: č,š,ć,ž,đ)
Formula in B1:

Please Login or Register  to view this content.

But formula doesn't work, and i don't know why

Any idea?

Thank you!

**martindwilson** · 09-26-2014, 07:08 AM

try like this
=iferror(LOOKUP(1;1/ISNUMBER(SEARCH({"a";"b";"c";"d"};A1)));0)

**zeko90** · 09-26-2014, 07:15 AM

Great formula, but not working on range of cell?

**sktneer** · 09-26-2014, 07:59 AM

Originally Posted by zeko90

Great formula, but not working on range of cell?

What do you mean by not working on range of cells. The formula was testing one cell A1.
If you want to check whether a range say A1:A10 contain any of these letters "a","b","c" or "d", try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter which you normally use in case of a regular excel formula.

Please Login or Register  to view this content.

The above formula will return 1 if any cell in the range A1:A10 contains any of these letters.

If this is not what you are trying to achieve, please upload a sample workbook with enough sample data along with the desired output shown manually.