+ Reply to Thread
Results 1 to 3 of 3

Look up and compare names from two columns, matching issues

  1. #1
    Valued Forum Contributor
    Join Date
    10-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    513

    Look up and compare names from two columns, matching issues

    Hi there,

    I have attached the worksheet.

    in "look from" worksheet, you see a list of names. Same thing on the "to update" worksheet. The only difference is that names from these two columns are NOT exactly the same. (there is always a space after the comma in the "look from" worksheet)

    What I would like to:
    look up each name found in "look from" on the "to update" sheet. If a matching name is found in "to update", then in column A of the corresponding name of worksheet "to update", I need to put in a "yes".

    Is the match() sufficient here? or is some kind of macro is needed?

    thank you any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Look up and compare names from two columns, matching issues

    Try:

    =IF(ISNUMBER(MATCH(SUBSTITUTE(B2,",",", "),'look from'!A:A,0)),"Yes","")

    copied down

    Note: This will not catch names that have an extra middle initial on one sheet and not the other...
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Valued Forum Contributor
    Join Date
    10-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    513

    Re: Look up and compare names from two columns, matching issues

    Hi,

    Great, it works!

    Is there any way to match the ones with middle initial? This is only possible in VBA then?

    Thanks
    Last edited by Lifeseeker; 07-18-2012 at 02:18 PM. Reason: figured out what the formula does

+ 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