+ Reply to Thread
Results 1 to 5 of 5

Find the row of the cell matching a keyword

  1. 11-25-2019, 01:37 PM #1
    billj
    billj is offline
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010, 2019
    Posts
    436

    Find the row of the cell matching a keyword

    I am looking for a nice formula for me to find the cell that contains a keyword. For example, assume the keyword is NBD. The column has data below:

    ADE PX
    ABM LG
    C NBD E
    XZ FD

    Therefore, the cell containing the keyword is C NBD E, which give me the row number 3.
    Reply With QuoteRegister To Reply
  2. 11-25-2019, 01:44 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Find the row of the cell matching a keyword

    Try:

    =MATCH("*"&D2&"*",A:A,0)

    with NBD in D2 and your list in column A.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 11-25-2019, 04:21 PM #3
    Begaver22
    Begaver22 is offline
    Registered User
    Join Date
    11-11-2019
    Location
    London
    MS-Off Ver
    microsoft pc
    Posts
    6

    Re: Find the row of the cell matching a keyword

    =match("*"&d2&"*",a:a,0)
    Reply With QuoteRegister To Reply
  4. 11-26-2019, 04:58 AM #4
    billj
    billj is offline
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010, 2019
    Posts
    436

    Re: Find the row of the cell matching a keyword

    Many thanks Glenn and Begaver22. It is really powerful for such a neat formula. Well learned!
    Reply With QuoteRegister To Reply
  5. 11-26-2019, 05:00 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Find the row of the cell matching a keyword

    Yep. It has all sorts of uses. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search for keyword in cell and return the numbers following the keyword in adjacent cell
    By xu9j2 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-02-2017, 11:02 AM
  2. Find keyword in a cell a return these keyworks
    By gildasl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2014, 05:23 PM
  3. Keyword Matching
    By sathishkm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2013, 11:50 AM
  4. keyword matching in a cell(compliated)
    By hk4kim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 05:30 PM
  5. [SOLVED] find and replace macro cell to keyword within cell
    By jimscott in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2012, 08:50 PM
  6. Copy keyword from one sheet, find that keyword in cells in column D and paste it under rel
    By vish621979 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  7. [SOLVED] Find keyword and insert hyperlink to cell
    By Sarge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1