Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Unanswered: JOIN 2 WS into one

    How can I merge two worksheets together using one column from each WS table that is a number, like ID#. What I want to find out is a reconcilliation of the 2 WS and what ID#'s do not match.

    HELP!!

  2. #2
    Join Date
    Nov 2003
    Posts
    300
    can I get any help on this???

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    If you're reconciling two sheets, you shouldn't merge them.

    What I normally do in this case is to make sure that the ID number is in the left-hand column both both ranges, and then name each range with something pithy that has meaning. Then, on a third sheet, copy both lists of ID numbers into the same column. You can then use the advanced filter option to filter the combined list in place, just retaining unique values. This gives you a complete list of all the ID numbers.

    Finally, use the IF, ISERROR and VLOOKUP formulae to determine which values are unique to one or the other sheet, and which are common to both.

    Also, this isn't an instant help service. Everyone who posts here is volunteering their time, and might not be able to check every day

Posting Permissions

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