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

Hi All:

I have a formula that I am working to tweak to search for multiple text.

• I want to look in a table for specific texts. Example: "Pol", "Occl", "Hap", and "Div"
• If the texts are found anywhere in the searched cells, I want the entire cell data returned.

This is the formula that is working for me for just 1 search criteria. For example:

Please Login or Register  to view this content.

I have tried putting "OR" after the iferror and dropping in the different specific texts...it bombs.

Any help would be appreciated!

Thanks

Ok, thanks! I was puzzled because it was returning my data, but some strange results as well.

Try this in B2:

=IFERROR(INDEX(C2:I2,SMALL(IF(ISNUMBER(SEARCH({"Pol";"Occl";"Hap";"Div"},C2:I2)),COLUMN(C2:I2)-2),1)),"") Ctrl Shift Enter

Hi 63falcondude:

Thanks so much, it's close! In the test data I attached, it works. But in my working spreadsheet, the column with the latest formula you provided returns "0"s for the records that should have the string returned. Any ideas what went wrong?

Hmm, not off the top of my head.

If you upload a more representative sample showing the issue, we can take a look.

Here's a scrubbed sample of what I am dealing with. Tried to maintain the error, hope it makes sense.

Change -2 to -6. This number corresponds to the column where the data starts.

Notice that in this sample, the data starts farther to the right than in the first sample.

This worked! Thanks so much! I had a suspicion it was the offset, but was kinda foggy on how to troubleshoot. Thank you again for your kind help!

Happy to help. Thanks for the rep!

I need following formula :-----------

1. If the cell in coumn Q contains CEMEX, put the value of “CEMEX Reuqest” in the new column cell

2. If the cell in column Q contains Customer, put the value of “customer Request” in the new column cell