Question: suppose I have values like

```
A   B    C
abc cde
bcd abc
cde afg
mn   mn

```

for column C I have used formula =IF(MATCH(A1;B2:B4;0);A1)

But its **giving wrong ouput** like below

```
A   B   C
abc cde  #N/A
bcd abc  #N/A
cde afg  #N/A
mn    mn    mn

```

since abc and cde in column A exist in column B **output should be something like this**:

```
A   B   C
abc cde  abc
bcd abc  #N/A
cde afg  cde
mn    mn    mn

```

Any help is appreciated.

Answer: 
I have tried your (modified) formula. It works fine!

```
=IF(MATCH(A1;B$1:B$4;0);A1)

```

Result:

![enter image description here](https://i.stack.imgur.com/aJdMk.jpg)

If you get #N/A errors, then it could be that the data in column A and column B are not exactly the same (hidden spaces). You could use =trim(A1) in C1 and =trim(B1) in D1 and copy it down, then run your formula in column E.
I have used this formula:

```
=IF(ISNA(VLOOKUP(A2;$B$2:$B$718;1;0));A2;"")

```

output is 

```
 A   B   C
abc cde  
bcd abc  bcd
cde afg  
mn   mn    

```