Need Help Comparing Data in Two Spreadsheets

Closed
Report
-
 Trowa -
Hello,

I have two excel spreadsheets, both of which contain customer account information. I need to compare the two to find all accounts that are common to both sheets.

On the first sheet, the account numbers appear in column A. On the second, they are in column D.

I'm sure there is a macro that can compare account numbers and pick out the ones that appear on both sheets. But, I don't write code. Can anyone help?

Thanks.

1 reply

Hi Galloc,

A macro might not be nessecary. Take a look at this solution:

I have used column E of sheet 2 to input the following formula:
=IF(ISERROR(VLOOKUP(D1,sheet1!$A$1:$A$7,1,FALSE)),"",VLOOKUP(D1,sheet1!$A$1:$A$7,1,FALSE))
Adjust the range of column A of sheet1 and then drag the formula down.

Now you have got a list of account numbers which exist on both sheets.

Is this a satisfying answer?

Best regards,
Trowa