Compare two columns and write which is existing in B in C Column

[uday1969]

Hi Guru's

Column A Column B Column C
1955 1123
1124 1127
1579 1128
1127 1129
1128 1130
1129 1131
1130 1132
1131 1133
1132 1123 1123
1133 1124 1124
1135

Above are the 3 columns, I would like have in common ones in C column. example I used 1123 and 1124. Hence What formula do I have to use it.

Regards
Uday

[Special-K]

=if(isna(vlookup(b1,a$1:a$11,1,0)),"",vlookup(b1,a$1:a$11,1,0))

[uday1969]

Hi

I am sorry, I want to put it different way.

1955 1123 1123
1124 1127
1579 1128
1127 1129
1128 1130
1129 1131
1130 1132
1131 1133
1132 1123
1133 1124 1124
1135 1100
1123 1101
1124 1102

I would like to compare with column B with Column A. If column B value exists in Column A then write it on Column C

Regards
Uday

[samba_ravi]

Pls attach sample file

[uday1969]

Hi Siva,

I have attached the file.

Regards
Uday

[samba_ravi]

c2=IF(ISNUMBER(MATCH(B2,A$2:A$904,0)),B2,"")
Try this and copy towards down