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.