Isnumber Search Multiple Criteria

**BDobb002** · 10-05-2023, 06:55 PM

I am trying to figure out a formula to return "True" if a cell contains any specific text out of a list of other cells.

For instance, cells A41 and A44 they contain a word that is in the cells Y2:Y16, so in cell S41 and S44 I'd like it to return "True".

Thanks!

**TMS** · 10-05-2023, 07:16 PM

I don't think any of those words are in column A

**BDobb002** · 10-05-2023, 08:37 PM

Sorry! Column B

**TMS** · 10-05-2023, 08:54 PM

This seems to work

Formula:

Please Login or Register  to view this content.

**BDobb002** · 10-05-2023, 10:40 PM

That worked!! Thank you!

**TMS** · 10-06-2023, 12:24 AM

You're welcome.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Isnumber Search Multiple Criteria

LinkBack

Thread Tools

Rate This Thread

Display

Isnumber Search Multiple Criteria

Re: Isnumber Search Multiple Criteria

Re: Isnumber Search Multiple Criteria

Re: Isnumber Search Multiple Criteria

Re: Isnumber Search Multiple Criteria

Re: Isnumber Search Multiple Criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Trouble with ISNUMBER SEARCH formula with multiple criteria

Looking for a more dynamic SUMPRODUCT(ISNUM(SEARCH option for a lot of data.

IF ISNUMBER SEARCH and OR with extra criteria?

[SOLVED] search criteria like small(if(isnumber(find.. with any code

[SOLVED] If/IsNumber multiple search criteria. Does syntax accept "OR"?

[SOLVED] Multiple Criteria Isnumber Search Array (with Attachment Example)

Multiple IF ISNUMBER SEARCH

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions