Displaying text on the right if it is matching

[pitaszek]

Here is the data table. I need to find values from the 2nd column in the 1st column and for instance display them in 3rd column as presented.

A	B
B	D	B
C	F
D		D
E
F		F
G

<tbody>
</tbody>

So if B from 2nd column is found in the 1st column, display it in the same row in the 3rd column.

 

[gsistek]

Assuming this data starts in A1, try in C1:
=IF(ISERROR(MATCH(A1,B:B,0)),"",A1)
and copy down.

 

[kpark91]

Maybe try
=IFERROR(IF(MATCH(A1,$B:$B,0)>0,A1,""),"")
in C1?