Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

How to compare column and spot the difference [Closed]

Report
Posts
1
Registration date
Tuesday August 22, 2017
Status
Member
Last seen
August 22, 2017
 -
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
 -
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.
See more

1 reply

Answer 1 / 1
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
 136
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
Ask a question