IF and SEARCH and OR..what I am doing wrong

[ihinojosajr]

I am searching 2 columns for "CRS". If one or both columns contain this value, I would like a response of CRS.

Works great when searching one colum: =IF(ISNUMBER(SEARCH("CRS",C12526)),"CRS","")

Not so great when trying 2 columns: IF(ISNUMBER(SEARCH("CRS",C12526)) Or (ISNUMBER(SEARCH("CRS",F12526)) ,"CRS","")

HELP!

Thanks in advance..

[sktneer]

May be this.......

Please Login or Register  to view this content.

[ihinojosajr]

BINGO! That worked! Thank You.

[Jonmo1]

What is in column D and E ?
IF CRS will NOT exist in D12526 or E12526, then try

=IF(COUNTIF(C12526:E12526,"*CRS*"),"CRS","")

[sktneer]

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.