Assume account numbers in column A of both sheets. Add a 'helper' column in
the first sheet with the long list. Put this formula into a cell in the
helper column in same row with first account number (assumed row 2)

=COUNTIF(Sheet2!A:A,A2)

Next choose that column and use Data | Filter and show rows with a zero as
the value in that column. Those left in view are the ones unmatched on
Sheet2 (where your short list is).

"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