+ Reply to Thread
Results 1 to 7 of 7

VLOOKUP to find values in text string???

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    VLOOKUP to find values in text string???

    I need to to highlight keywords within a block of text (string). I don't need to necessarily return a value with the VLOOKUP. I just need to compare keyword list in Column B to the Text in Cell A1. If the word from the list appears in the text, I need it to be highlighted for every instance.

    EXAMPLE
    Text String (A1)

    Welcome to Jake's Car Accessories website. We have all of your car accessory needs including car covers, truck covers, custom car grills and other car accessories.

    Keyword List (Column B)
    car accessory
    car covers
    truck covers
    car accessories


    I think VLOOKUP only works on lists. I'm not sure if it is possible to do this. Any ideas or alternative suggestions are greatly appreciated.

    Thanks!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VLOOKUP to find values in text string???

    You need code to do this:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re: VLOOKUP to find values in text string???

    Dude.... you are so freaking awesome! Exactly what I was looking for

  4. #4
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re: VLOOKUP to find values in text string???

    Now.... one quick thing.

    Say for instance I have a Column C with hyperlinks. Could this code be modified to dynamically insert hyperlinks based on the keywords from maybe a VLOOKUP?

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VLOOKUP to find values in text string???

    That's a completely different question for a completely different thread.

  6. #6
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Re: VLOOKUP to find values in text string???

    Well.... thanks a lot for your time and help. I really appreciate that

  7. #7
    Registered User
    Join Date
    12-18-2012
    Location
    lisle il
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: VLOOKUP to find values in text string???

    How do you insert this code into your excel worksheet?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1