Hi,

Try this:

big sheet (15000):
A B C
1 account# Name =VLOOKUP(A1,smallsheet!$A$1:$A$8000,1,false)

copy drag the formula to end of your data (15000) then you should have 7000
of "N/A" .

Thanks,



--
Farhad Hodjat


"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