Need Help Comparing Data in Two Spreadsheets Closed

Question

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.

Trowa · Answer

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

Need Help Comparing Data in Two Spreadsheets

1 response

Similar discussions

Subscribe To Our Newsletter!