Comparing two different worksheets, then bringing data over.

[J Lowe]

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

 

[Barrie Davidson]

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,