VLookup to bring in not true data.

  • Thread starter Thread starter Sarita
  • Start date Start date
S

Sarita

Hi,

I need to create an if statement or vlookup that will compare both columns
and bring back the results that is not true. I know what matches so
basically I want to see all the data that doesn't match. I want to see the
results of everything in Account II that doesn't match Account. Help
everything I try doesn't work.

Sarita aka non excel expert!!!

Account Account II
154623 154142
154632 154189
154639 154632
154649 154636
154861 154739
154996 154840
155765 154850
155008
155765
155801
155829
159002
160632
160932
160934
166243
166249
166311
166448
 
If you are ok if highlight nonmatching cells through conditional format, try
"format only unique or duplicate values"
 
Thank you for trying but that isn't what I wanted to do. Anyone else have any
other answers?
 
Back
Top