Related:

- Need Help Comparing Data in Two Spreadsheets
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Data transmission cable - Guide
- How to be offline in whatsapp when data is on - Guide

## 1 response

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