Search column for range of text

Hi everyone,

 

I am struggling with the following.  I have a lookup table called LookupTbl which consists of keywords in column A and then a category in column B.

I then have a seperate table on another worksheet with a set of data.  One column on this table is called “Description”.  Each cell in this column is a string of text.  

My problem is to look through the text in each cell in the “Description” column and if the cell contains any of the keywords in the lookupTbl (Column A), it should return the category in column B.  

It should also only return the category for the first keyword that is found in the string of text.

I hope this make sense and that someone can help me.

 

By: Jacobus

11 thoughts on “Search column for range of text

  1. lebron 13

    The next time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I know it was my option to read, but I truly thought youd have one thing interesting to say. All I hear is a bunch of whining about one thing that you would repair for those who werent too busy in search of attention.

  2. tinyurl.com

    Hi there it’s me, I am also visiting this web page on a regular basis, this web page is genuinely fastidious and the users are in fact sharing fastidious thoughts.

  3. what coconut oil

    Hello! Someone in my Myspace group shared this site with us so I came
    to give it a look. I’m definitely enjoying the information. I’m
    book-marking and will be tweeting this to my followers!
    Outstanding blog and excellent design.

  4. golden goose

    Can I simply say what a relief to find someone who really knows what theyre speaking about on the internet. You definitely know learn how to bring an issue to mild and make it important. More people need to read this and perceive this aspect of the story. I cant believe youre no more widespread since you definitely have the gift.

  5. vans outlet

    When I initially commented I clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I get 4 emails with the identical comment. Is there any approach you possibly can take away me from that service? Thanks!

  6. ps4 games

    That is a really good tip particularly to those fresh to the blogosphere.
    Simple but very accurate information… Thanks for sharing
    this one. A must read post!

  7. calvin klein outlet

    Youre so cool! I dont suppose Ive read anything like this before. So nice to search out someone with some unique thoughts on this subject. realy thanks for starting this up. this website is something that’s needed on the web, someone with somewhat originality. helpful job for bringing one thing new to the internet!

  8. coach factory outlet

    Nice post. I be taught something tougher on totally different blogs everyday. It’ll all the time be stimulating to learn content material from other writers and observe a bit something from their store. I抎 desire to make use of some with the content on my blog whether or not you don抰 mind. Natually I抣l provide you with a hyperlink on your web blog. Thanks for sharing.

  9. ps4 games

    Hello terrific website! Does running a blog like this take a lot of work?
    I have absolutely no expertise in programming however I had been hoping to
    start my own blog soon. Anyway, if you have any
    recommendations or tips for new blog owners please share.
    I understand this is off topic nevertheless I
    simply wanted to ask. Many thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *