Use Vlookup to match data in two seperate she Closed

Question

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.

mubashir aziz · Accepted Answer

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

venkat1926 · Answer

quote
f the numbers match in both sheets 
unquote

which cells in the two sheets. some more classifications are required in your query

Use Vlookup to match data in two seperate she

2 responses

Similar discussions

Subscribe To Our Newsletter!