Excel 20007 Matching Values from 2 sheets

[cashew1970]

Hello All,,

I have a workbook that contains 2 sheets

Sheet1 contains data of accounts active on a system, and A1 has the account numbers in

Sheet2 contains info of people who have paid for accounts and B1 has the acount numbers in


I am looking to highlight all of the accounts in Sheet 2 that do not appear in sheet1 so that we can identify all of the accounts that have not registered but are still paying for a service

I have tried Vlookup, but appear to be failing! and I really do not like Outlook 2007!!

Regards

Martin

 

[ravishankar]

Hi
Try match function
in any free column say C
C1 = if(iserror(match(B1,sheet1!A1:A100,0)), "no match", "match found")
Ravi