+ Reply to Thread
Results 1 to 6 of 6

Title Keyword Matching

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Title Keyword Matching

    Hi All,

    I have the tile in column A, and I have keywords mentioned them in column E. Here I need to update the keyword which is contains the exact keyword which I had mentioned. Please check my attachment file for better understanding.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: Title Keyword Matching

    maybe this !!!
    Attached Files Attached Files

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Title Keyword Matching

    B2=IFERROR(LOOKUP(2,1/(MAX(INDEX(ISNUMBER(SEARCH(E$2:E$8,A2))*LEN(E$2:E$8),0))=(SEARCH(E$2:E$8,A2)>0)*LEN(E$2:E$8)),E$2:E$8),"")
    Try the above, copy and paste towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Title Keyword Matching

    Quote Originally Posted by vasc View Post
    maybe this !!!
    In first record. It should match Vice President, but this is updating only President.

  5. #5
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: Title Keyword Matching

    maybe THIS?

    row H or row I
    Attached Files Attached Files

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Title Keyword Matching

    Another Option...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Look up a value from a table after matching a keyword
    By khanaran in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-30-2019, 01:46 PM
  2. Issue - Cannot open thread - possible title keyword problem
    By teylyn in forum Suggestions for Improvement
    Replies: 3
    Last Post: 03-08-2018, 10:11 AM
  3. [SOLVED] Keyword Matching
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2015, 06:33 PM
  4. [SOLVED] Keyword Matching & Categories
    By leeandoona in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2014, 08:29 AM
  5. Keyword Matching
    By sathishkm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2013, 11:50 AM
  6. keyword matching in a cell(compliated)
    By hk4kim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 05:30 PM
  7. keyword, matching and breaking up??
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-17-2010, 07:47 PM

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