Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Comparing two different worksheets, then bringing data over.

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have two worksheets that have similar data. The new worksheet contains clients and fees collected while the original worksheet contains this information plus another twenty fields that I need.

    My goal is to avoid the duplication of work.

    Both sheets contains clients that are the same, but the new sheet also contains new clients and perhaps has lost a few clients.

    Is there a way to:

    A.) Compare the data in A2:A500 (Worksheet one) with A2:A500 (Worksheet two)...

    B.) Where ever the information in the columns are the same, then take the information in C2 - V2: C500 - V500 (worksheet one) and fill in the same cells in worksheet two?

    I am guessing this will be an If...then statement, but am not quite sure how to set it up successfully.

    Can anyone help with this?

    Thank you,
    Jason

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 11:13, J Lowe wrote:
    I have two worksheets that have similar data. The new worksheet contains clients and fees collected while the original worksheet contains this information plus another twenty fields that I need.

    My goal is to avoid the duplication of work.

    Both sheets contains clients that are the same, but the new sheet also contains new clients and perhaps has lost a few clients.

    Is there a way to:

    A.) Compare the data in A2:A500 (Worksheet one) with A2:A500 (Worksheet two)...

    B.) Where ever the information in the columns are the same, then take the information in C2 - V2: C500 - V500 (worksheet one) and fill in the same cells in worksheet two?

    I am guessing this will be an If...then statement, but am not quite sure how to set it up successfully.

    Can anyone help with this?

    Thank you,
    Jason
    Jason, place this formula in C2 and copy to C2:V500.

    =IF(ISNA(VLOOKUP($A1,Sheet2!$A$2:$V$500,COLUMN(),0)),0,VLOOKUP($A1,Sheet2!$A$2:$V$500,COLUMN(),0))

    This will return the value 0 if no match is found. If you want it to be blank, replace 0 with "".

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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