Comparing values of two Excel sheets [Solved/Closed]

issa - Mar 1, 2010 at 03:02 AM - Latest reply:  dh
- Jun 10, 2017 at 09:04 AM
I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e.

Column A=IP Codes

Column A=IP Codes

Compare the two columns and highlight the unique IP Codes.

Awaiting for your immediate response. Thank you.

See more 

2 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 1, 2010 at 08:43 AM
Thank you
Use VLOOKUP formula in sheet 2

If your data starts in sheet 2 from A2 you can use


If will say "NOT FOUND" if there is no match else would remain ""

Thank you, rizvisa1 5

Something to say? Add comment

CCM has helped 1805 users this month

just what doctor ordered thank you