+ Reply to Thread
Results 1 to 3 of 3

Compare Lists and match data

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2019
    Posts
    26

    Compare Lists and match data

    I have two lists and both have a Loan Number and a Social Security number.
    Sheet 1
    Column A Column B
    Loan Number Social Security Number

    Sheet 2
    Column A Column B
    Loan Number Social Security Number

    In columns C & D Sheet 1
    1. Match Sheet 1 Social Security Number to Sheet 2 Social Security Number. Place the matched Social Security Number in column C if there is a match for both Social Security Number and for the Loan Number.
    2. Match the Loan Number from Sheet 1 to Sheet 2 Loan Number. Place the matched Loan Number in column D if there is a match for both Social Security Number and for the Loan Number.

    The challenge is to pair the two variables because there may not always be a match for both items. If there is not a match to both items the cell needs to be blank.

    There might be might be many of the same loan numbers or Social Security Numbers but only one combination where both match. I only need to see where the two match,


    Sheet 1
    Loan Number Social Security Number
    abcd 123
    abcd 345
    efg 123
    lmn 123
    opq 567

    Sheet 2
    Loan Number Social Security Number
    aaa 789
    bbb 458
    abcd 345
    efg 852
    efg 123

    Results Next to Sheet 1 if BOTH items match
    Sheet 1 Sheet 2 Results
    Loan Number Social Security Number Loan Number Social Security Number Loan Number Social Security Number Only if both match
    abcd 123 aaa 789
    abcd 345 bbb 458
    efg 123 abcd 345 abcd 345 Match
    lmn 123 efg 852
    opq 567 efg 123 efg 123 Match
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Compare Lists and match data

    In c3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and press CTRL+SHIFT+ENTER
    in d3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and press CTRL+SHIFT+ENTER
    In E3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and press CTRL+SHIFT+ENTER
    Attached Files Attached Files
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    Colorado
    MS-Off Ver
    Excel 2019
    Posts
    26

    Re: Compare Lists and match data

    Thank you for the help, this is incredibly valuable. Take care.

+ 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 lists - display items without a match
    By CJBeaty in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2021, 04:47 PM
  2. [SOLVED] Compare two lists and fetch the match
    By santnair0599 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-30-2017, 05:10 AM
  3. 2 lists of data I need to compare and a formula to match up
    By Jashebb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2015, 06:11 AM
  4. [SOLVED] VBA loop to compare two lists and modify cells in rows that don't match
    By Mutt0nJeff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2014, 08:05 AM
  5. Compare/Match two lists with multiple variables
    By cjwe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2013, 07:29 AM
  6. Replies: 4
    Last Post: 12-04-2012, 04:45 PM
  7. Compare two lists and give exact match
    By mccrimmon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2008, 07:46 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