+ Reply to Thread
Results 1 to 5 of 5

How to compare text of same row in two different columns and return matching words?

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    32

    How to compare text of same row in two different columns and return matching words?

    Hi,
    I need to compare two very long lists of company names. I wish to compare the name in col A with the name in the same row in col B and return the matching words in the same row in C. I have tried Fuzzy Lookup Add-in but somehow it does not work in Excel 2007.

    The sample is attached with indicative results given in column C.

    Any help will be highly appreciated.

    Best regards,
    guest
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: How to compare text of same row in two different columns and return matching words?

    Maybe give this code a try. PS: Text comparison is case sensitive. Apple <> apple

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to compare text of same row in two different columns and return matching words?

    This is the best I could come up with. Hope you can find a use for it.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-14-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    32

    Re: How to compare text of same row in two different columns and return matching words?

    Thank you for the help, John. The code is very helpful.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: How to compare text of same row in two different columns and return matching words?

    You're welcome. Glad to help out and thanks for the feedback. But beware it is not fullproof.

+ 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. Compare columns and finding matching values/text
    By debake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2014, 09:27 AM
  2. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  3. Replies: 2
    Last Post: 07-17-2013, 11:48 AM
  4. Replies: 1
    Last Post: 04-21-2013, 08:36 AM
  5. [SOLVED] Find matching words in 10 columns and add row numbers of matching words
    By zeke 29 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-03-2012, 09:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1