Report

Comparing values of two Excel sheets [Solved/Closed]

Ask a question issa - Last answered on Jun 10, 2017 at 09:04 AM by dh
Hello,
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.

Sheet#1
Column A=IP Codes

Sheet#2
Column A=IP Codes

Compare the two columns and highlight the unique IP Codes.


Awaiting for your immediate response. Thank you.


ISSA
See more 
Helpful
+5
plus moins
Use VLOOKUP formula in sheet 2

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

=IF(ISERROR(VLOOKUP(A2, Sheet1!A:A,1,FALSE)), "NOT FOUND", "")

If will say "NOT FOUND" if there is no match else would remain ""
dh- Jun 10, 2017 at 09:04 AM
just what doctor ordered thank you
Reply

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!