How to compare column and spot the difference

Closed
norasiken Posts 1 Registration date Tuesday August 22, 2017 Status Member Last seen August 22, 2017 - Updated on Aug 22, 2017 at 10:08 PM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Aug 25, 2017 at 02:59 PM
Hi. I really need help to solve this problem.

I have few hundred data in 4 columns as below. Is there's anyway I can use excel formula to find the differences.

If ID1 match with ID2, than COURSE1 must match COURSE2.
If COURSE1 not match with COURSE2, than it will return 'error' in ERROR column.

Let say for ID1 .... 111 is abc, but in course2 its listed jkl...than error message will appeared.

ID1.........course1..........ID2............course2..........error
111.........abc................444............jkl
222.........def................555............abc
333.........ghi................111............jkl
444.........jkl.................222............def
555.........abc................333...........ghi

Hope you understand my explanation. Thanks in advanced.

1 reply

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Aug 25, 2017 at 02:59 PM
norasiken, Good afternoon.

Suppose your data at A1:D6

Try to use:

E2 --> =IF(VLOOKUP(C2,$A$2:$B$6,2,FALSE)<>D2,"Error","")
Copy it down.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0