+ Reply to Thread
Results 1 to 10 of 10

Match two columns of names while keeping data in rows aligned

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Match two columns of names while keeping data in rows aligned

    I have six columns with the following headings and I want to use a formula to match up the Person Names while keeping the rows of data attached to the names aligned.

    A B C D E F
    Store Lic# Name1 Name2 ID StoreName

    Column's A, B, C contain 1000 rows of records and columns D, E, F contain 1500 rows of records. If the names in C2 & D2 match the rows with their corresonding data should line up.

    But if the name in C2 does not match D2 but does match D3, then D2 should be BLANK and C2 would line up with D3.

    I spent all day yesterday aligning the names by hand only to discover the attached rows did not stay aligned. Huge mess.

    I would appreciate any help proided.

    Thank you

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,327

    Re: Match two columns of names while keeping data in rows aligned

    Hi and welcome to the forum

    Im thinking that you probably need to use vlookup() or index/match() for this, but fi you could upload a sample (without sensitive info), I could give a better result...

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Match two columns of names while keeping data in rows aligned

    I have attached a sample file.

    Thanks,
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,715

    Re: Match two columns of names while keeping data in rows aligned

    Try it in G2:
    =VLOOKUP($C2,$D$2:$F$13,2,0)
    H2:
    =VLOOKUP($C2,$D$2:$F$13,3,0)
    Drag down.
    Copy/paste value column G and H
    Delete D,E,F column.
    Hope it works.

  5. #5
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Match two columns of names while keeping data in rows aligned

    Thanks. I will give it a try.

  6. #6
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Match two columns of names while keeping data in rows aligned

    FDibbins,
    The formula didn't work quite right.

    The name in column C is looking for a match in column D.
    If it finds a match in column D the name in column C should line up with the name in column D and bring the information in column A & B as one record, (A,B,C).

    Thanks,
    SpaceWheels
    Attached Files Attached Files

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,327

    Re: Match two columns of names while keeping data in rows aligned

    That was bebo's formula, not mine?

  8. #8
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Match two columns of names while keeping data in rows aligned

    Oops,
    Sorry about that.

  9. #9
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,025

    Re: Match two columns of names while keeping data in rows aligned

    Take a look at this.
    The green cells is what your looking for.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  10. #10
    Registered User
    Join Date
    03-27-2013
    Location
    Fort Worth, TX
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Match two columns of names while keeping data in rows aligned

    I have plugged in the formula but I don't know how to start it.

+ 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