Find Matching Words in Text String with Excel Formula

Having a bit of difficulty determining where I’m going wrong but here is what I’m trying to do:

I have a column labeled “Category” and it contains multiple text values from a drop down list.  Captured in parenthesis in each text value is either “Tier 1”, “Tier 2 Blanket Approval” or “Tier 2”.  These values are not repeated elsewhere in the string of text.

In a seperate column called “Approved by”, based upon the Tier from the Category column, I would like to return a text value of “Wing” or “EC”.  if the value of the Category column is either “Tier 1” or “Tier 2 Blanket Approval” then I would like to return a “Wing” in the “Approved by” column.  If the value is just “Tier 2” then I would like to return “EC” in the “Approved by” column.

I thought I could use the IF, OR and SEARCH functions to accomplish this but when I input the following:  =IF(OR(SEARCH(“Tier 1”,H2),(SEARCH(“Tier 2 Blanket Approval”,H2))),”Wing”,”EC”) all I get is the dreaded #VALUE!

Where am I going wrong?  Thanks.

2,116 thoughts on “Find Matching Words in Text String with Excel Formula


    An interesting discussion is definitely worth comment. I do think that you should write more on this subject, it may not be a taboo matter but generally people do not talk about such topics. To the next! Kind regards!!

  2. hiking

    This is the perfect web site for anybody who wants to understand this topic. You know a whole lot its almost hard to argue with you (not that I actually would want to…HaHa). You definitely put a brand new spin on a subject that’s been written about for decades. Wonderful stuff, just wonderful!

  3. Fast cash

    I must voice my passion for your kindness for folks that actually need help on that study. Your very own commitment to getting the solution all over was extraordinarily advantageous and have continuously empowered guys and women like me to reach their desired goals. Your entire warm and friendly instruction means this much to me and further more to my fellow workers. Thank you; from all of us.

  4. iamgutsclub

    Good web site you have got here.. It’s hard to find good quality writing like yours nowadays. I truly appreciate people like you! Take care!!

  5. HP printer driver

    Spot on with this write-up, I truly believe that this amazing site needs a great deal more attention. I’ll probably be back again to read more, thanks for the advice!

  6. เว็บ w88 pantip

    hello there and thank you for your information – I’ve certainly picked up something new from right here. I did however expertise several technical issues using this site, since I experienced to reload the web site many times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Well I am adding this RSS to my email and could look out for a lot more of your respective exciting content. Ensure that you update this again very soon..

  7. vivo slot

    Greetings! Very helpful advice within this post! It is the little changes which will make the most significant changes. Thanks a lot for sharing!


    Oh my goodness! Impressive article dude! Thank you, However I am encountering difficulties with your RSS. I don’t know why I cannot subscribe to it. Is there anybody else getting similar RSS issues? Anybody who knows the solution can you kindly respond? Thanx!!

Comments are closed.