Menu
  1. Accueil
  2. Forum
  3. Office Software
  4. Excel

Comparing values of two Excel sheets [Solved/Closed]

Report
-
 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

1 reply

Answer 1 / 1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 756
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 ""
Thank you
5
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4098 users have said thank you to us this month

Report

just what doctor ordered thank you
Ask a question