Compare two text columns

[ms02kk1]

I want to compare two columns in excel that have text in each cell. If in column 2 there is the same text with the column 1 then next to column 1 I need to be post next to the cell that there is the same text the word YES and if not then next to column 1 to be post NO. Column 1 cells is from A1:A16, Column 2 is from C1:C4 and the column with YES and NO is from B1:B14. See example below:



Column 1 Column 2

a NO c
b NO h
c YES l
d NO n
e NO
f NO
g NO
h YES
i NO
j NO
k NO
l YES
m NO
n YES

 

[PaddyD]

hi - welcome to the board.

=if(isnumber(match(a1,$b$1:$b$10,0)),"Yes","No")

...adjust ranges to suit.

 

[ms02kk1]

Thanks! You saved me a lot of time in my project

 

[PaddyD]

You're welcome.