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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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