Combining data from 2 columns if they match each other

[fsanjaya]

Hello, I was wondering if anyone knows how to combine data from 2 separate columns into a new column only if they match each other? Attached below is a sample:

A and B are the 2 columns and C is the column containing the combined data.

 

[fsanjaya]

Unfortunately, I am unable to replicate your error, so the problem should be with your data.

Book2
	CJ	CK	CL
2
3
4
5
6
7
8		184	184
9		184	184
10	184		184
11
12
13
14
15	185
16
17
18
19
20	188
21
22	190
23
24
25		216	216
26
27	216		216
28
29
30
31
32	220
33
34	220
35
36
37
38		221	221
39
40	221		221
Sheet2

Cell Formulas
Range	Formula
CL2:CL40	CL2	=IF(COUNTIF($CJ$2:$CJ$40,$CK2),$CK2,IF(COUNTIF($CK$2:$CK$40,$CJ2),$CJ2,""))

That would make sense, thank you very much for helping me!