Thanks all of you! I'll give it a try this weekend!

"Scoops" wrote:

On 18 May, 22:14, joey wrote:
I have a worksheet that has all account numbers and names - 15,000 of themand
another worksheet that has some of the same account number and names - about
8,000.

Is there a way in Excel to match records so that I can see the 7,000 records
that are not associated with the 2nd worksheet? Or, do I need to use Access.

Thanks

Hi Joey

In Book2 try:

=IF(ISNA(MATCH(C5,[Book1]Sheet1!$A$1:$A$15000,0)),"Not found","Found")

Regards

Steve