Use Vlookup to match data in two seperate she [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I was wondering if you guys could help me out with all of your excel knowledge. I have compiled a big database in two seperate sheets with mostly the same information. I need to see if the numbers match in both sheets and if they do not match I would like them to be highlighted red. This is to see where there are discrepencies in my data. Now the rows are not in the exact same order but the data in the colums should be the same.

How can I do this. I assume I would use a vlookup? Any help would be greatly appreciated.

Thanks.

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Suppose you have two sheets Sheet 1 and Sheet 2 now you want to hight light the cells in sheet 1 which are not in sheet 2 ...........

1. Select the range of column in sheet 2 and give then a name suppose data is in A column now select the A1:A100 and by using inert > range > now give the name my_range_sheet_2

2. now select the cells from A1:A100 in sheet 1 and go in Format>conditional formatting > Select Formula is in Condition 1 and paste this formula =ISERROR(MATCH(A1,my_range_sheet_2,0)) and format the back ground as red

All the values which are not in sheet 2 will be highlighted .....

you can repeat the same for sheet 2 as well ........






9
Thank you

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

CCM 4008 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
quote
f the numbers match in both sheets
unquote

which cells in the two sheets. some more classifications are required in your query