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

44 thoughts on “Search column for range of text

  1. yeezy boost

    I simply had to say thanks all over again. I am not sure the things I could possibly have tried without the type of ideas provided by you about such problem. It had been the frightening dilemma in my position, however , observing the well-written way you handled it made me to jump for joy. I am just happy for this work and even believe you know what a great job you happen to be accomplishing instructing most people using a web site. I am certain you haven’t come across all of us.


    I really like your blog.. very nice colors & theme.
    Did you create this website yourself or did you hire someone to do it for you?
    Plz reply as I’m looking to construct my own blog and would like
    to find out where u got this from. many thanks

  3. adidas superstar

    I precisely wished to appreciate you yet again. I’m not certain what I could possibly have worked on in the absence of the information documented by you about this area of interest. It previously was the difficult condition in my circumstances, nevertheless taking a look at the very specialized avenue you solved that forced me to leap for joy. I am grateful for this work and thus hope that you recognize what an amazing job you are always accomplishing educating many people via your blog post. I’m certain you haven’t got to know all of us.

  4. balenciaga sneakers

    My husband and i got absolutely ecstatic Emmanuel managed to do his researching through your ideas he obtained when using the weblog. It is now and again perplexing just to always be making a gift of hints which people today have been trying to sell. We really grasp we’ve got the website owner to thank because of that. The main illustrations you made, the simple web site navigation, the friendships you aid to foster – it’s mostly superb, and it’s letting our son and our family feel that this theme is awesome, which is certainly very pressing. Thank you for all!

  5. curry shoes

    I precisely wished to appreciate you again. I do not know the things that I would’ve gone through without the actual pointers shown by you directly on such question. It actually was a very alarming circumstance in my view, nevertheless taking a look at a new specialized fashion you treated the issue took me to cry over fulfillment. Now i’m grateful for this service and then trust you realize what an amazing job you were getting into teaching most people through the use of your websites. I am certain you have never encountered any of us.

  6. zx flux

    Thanks so much for providing individuals with an extremely splendid possiblity to discover important secrets from this web site. It can be very brilliant and as well , jam-packed with fun for me personally and my office colleagues to visit your blog really thrice per week to read through the new guides you will have. Not to mention, I am just at all times fascinated with all the surprising principles you serve. Some 3 points in this posting are surely the simplest we have all had.

  7. coach bags

    I am only writing to make you be aware of what a incredible discovery my wife’s daughter obtained studying your web site. She came to understand too many pieces, not to mention what it’s like to possess a great coaching style to have certain people just grasp some extremely tough subject areas. You undoubtedly surpassed readers’ expectations. I appreciate you for giving the good, trustworthy, explanatory and in addition fun tips about the topic to Ethel.

  8. off white clothing

    I in addition to my buddies were found to be reading the good helpful tips found on your web site and then the sudden I had a horrible suspicion I had not thanked the web site owner for those tips. The young boys came for that reason thrilled to study all of them and already have simply been having fun with those things. Many thanks for indeed being well thoughtful and also for pick out this kind of marvelous things millions of individuals are really desirous to learn about. Our own honest apologies for not expressing gratitude to earlier.

  9. sling tv best package 2020

    I am not sure where you are getting your information,
    but good topic. I needs to spend some time learning more or understanding more.

    Thanks for fantastic information I was looking for this information for my mission.

  10. nike max

    Thanks a lot for giving everyone such a splendid opportunity to read from this blog. It’s always very terrific plus packed with a great time for me and my office mates to visit your web site not less than thrice per week to read through the new tips you have got. Not to mention, I’m just at all times astounded for the excellent concepts you serve. Some two tips in this posting are surely the finest we’ve had.

  11. sling tv

    Excellent post. I was checking constantly this blog and I’m
    impressed! Very helpful info particularly the last phase 🙂 I maintain such information a lot.
    I was looking for this particular information for a very lengthy time.
    Thank you and best of luck.

  12. supreme clothing

    I would like to convey my admiration for your kind-heartedness in support of those individuals that actually need assistance with this one field. Your special dedication to getting the message throughout turned out to be rather insightful and has truly enabled others like me to reach their targets. This warm and friendly publication means much to me and especially to my mates. Thanks a ton; from all of us.

  13. supreme new york

    I’m commenting to make you be aware of of the awesome experience my cousin’s child found viewing your blog. She came to understand so many details, which included how it is like to have a marvelous giving mindset to have many others without hassle thoroughly grasp some problematic topics. You really did more than readers’ expectations. Thank you for presenting those good, trustworthy, informative and unique tips on the topic to Mary.

  14. converse shoes

    I am just writing to let you be aware of of the perfect discovery my princess obtained reading through your blog. She came to find a wide variety of things, which included what it’s like to have an awesome helping nature to make the others without difficulty know just exactly various hard to do subject matter. You really exceeded visitors’ desires. Thank you for displaying such helpful, dependable, educational and as well as cool tips about that topic to Emily.

  15. sling tv

    We stumbled over here coming from a different website
    and thought I might as well check things out. I like what
    I see so now i’m following you. Look forward to looking at your web page for a second time.

  16. adidas tubular shadow

    I want to express some thanks to this writer just for rescuing me from this dilemma. Because of checking through the world-wide-web and getting basics that were not helpful, I believed my life was over. Being alive devoid of the approaches to the difficulties you’ve resolved by means of your post is a serious case, and the ones which might have in a wrong way affected my career if I had not noticed your web blog. Your own personal natural talent and kindness in maneuvering all things was valuable. I’m not sure what I would have done if I hadn’t come across such a step like this. I can also at this point relish my future. Thanks very much for your specialized and sensible guide. I won’t be reluctant to recommend your web page to anybody who would need guidance on this issue.

  17. sling tv

    Undeniably believe that which you said. Your favorite reason appeared
    to be on the web the simplest thing to be aware of.

    I say to you, I definitely get annoyed while people think about worries that they plainly do not
    know about. You managed to hit the nail upon the top and defined
    out the whole thing without having side-effects , people
    can take a signal. Will probably be back to get more.

  18. hermes bag

    I am also writing to let you be aware of of the really good experience my wife’s child experienced reading through your site. She picked up so many things, which included how it is like to possess an excellent helping heart to let most people just gain knowledge of chosen hard to do topics. You undoubtedly surpassed visitors’ expected results. Thank you for imparting the interesting, trusted, edifying as well as cool tips about the topic to Gloria.

  19. golden goose

    My husband and i have been so delighted Ervin could deal with his basic research from your precious recommendations he gained through the web site. It is now and again perplexing to simply choose to be freely giving ideas which some people may have been selling. And we figure out we have the website owner to give thanks to for this. All the explanations you’ve made, the simple site menu, the relationships you can assist to create – it’s everything powerful, and it’s really letting our son in addition to our family recognize that this subject is amusing, which is really fundamental. Many thanks for the whole thing!

  20. balenciaga shoes

    I precisely wished to thank you very much all over again. I am not sure the things I might have made to happen in the absence of the type of strategies revealed by you about such question. It had become an absolute alarming circumstance for me personally, however , considering the very professional tactic you resolved the issue made me to leap with delight. Now i’m happier for the help and then trust you know what a great job you are always carrying out training the others using a web site. I’m certain you haven’t got to know any of us.

  21. jordan retro

    I have to express thanks to this writer for bailing me out of such a situation. Just after surfing around through the the web and getting tricks which are not beneficial, I figured my life was done. Living minus the strategies to the problems you’ve sorted out through your good article is a critical case, and ones which might have negatively affected my entire career if I hadn’t encountered your web blog. Your skills and kindness in maneuvering all the pieces was useful. I don’t know what I would have done if I hadn’t discovered such a thing like this. I can at this point look ahead to my future. Thank you so much for your high quality and result oriented guide. I will not be reluctant to endorse the website to anybody who should receive recommendations about this matter.

  22. ps4 games

    Hello are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and set up my own. Do you
    require any coding expertise to make your own blog? Any help would be
    really appreciated!

  23. quest bars cheap

    Howdy, I think your web site could possibly be having browser compatibility problems.

    When I look at your website in Safari, it looks fine but when opening in I.E., it has some overlapping issues.
    I just wanted to provide you with a quick heads up!
    Besides that, wonderful website!

  24. quest bars cheap

    Hi there excellent website! Does running a blog similar to this take a large amount of work?

    I’ve no knowledge of coding but I was hoping to start my own blog soon.
    Anyway, should you have any recommendations or tips for new blog owners please
    share. I know this is off subject but I just needed to ask.


  25. 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!

  26. 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.

  27. 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!

  28. 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!

  29. 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!

  30. 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.

  31. 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.


    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.

  33. 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.

Comments are closed.