Hello,

I have a workbook with 2 sheets. The first sheet is Deposits and the second is Loans. Both sheets are sorted by Tax ID number. The Deposit sheet has 5729 records and the Loan sheet has 3202. I need to compare the Deposit sheet to the Loan sheet to find customers who have a deposit account but DO NOT have a loan account. I want to get the results for customers without a loan on a third sheet named Dep_Cust_With_No_Loan. The Deposit sheet has one more column than the Loan sheet but beside that the 2 sheets are basically the same. It's been a while since I've worked with Excel. Is there a LOOKUP formula or other means to accomplish this task? Any help will be greatly appreciated.

Thank you.

Dave