Results 1 to 3 of 3

Thread: Matching First/Last Name and Combining Info into New Sheet

  1. #1

    Matching First/Last Name and Combining Info into New Sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Iím trying to combine information from two spreadsheets into one by matching the last name and first name from each.

    So, for instance, in sheet 1, I have last name and first name in separate cells followed by info in cells after. In a separate sheet I have (in about half of the cases) the same Last Name and First Name followed by different info in cells after.

    I want to combine the two sheets into one sheet by matching the Last Name and First Name followed by all of the pertinent info from both sheets.

    If the Last and First Name is not present in both sheets I still want it to populate in the new sheet with Last and First name followed by the info from the 1 sheet.

    Any help is appreciated.

  2. #2
    Hi,

    Please share your sample workbook.

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    You would be better using a macro for this instead of a formula, hows your VBA skills?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •