VLookup to bring in not true data.
 

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

VLookup to bring in not true data.
 

If you are ok if highlight nonmatching cells through conditional format, try
"format only unique or duplicate values"
"Sarita" wrote:

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

VLookup to bring in not true data.
 

Thank you for trying but that isn't what I wanted to do. Anyone else have any
other answers?


"Narnimar" wrote:

If you are ok if highlight nonmatching cells through conditional format, try
"format only unique or duplicate values"
"Sarita" wrote:

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

VLookup to bring in not true data.
 

Sarita...

why don't you use countif, after that filter for value 0...

hope this help

"Sarita" wrote:

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