If Statement Question

[NancyManthe]

How do I write an IF statement for: Column A has names in it. In Column M, I also have names. In column N I would like a formula that looks for the name value that is in N2 and if there is a match from column A, then populate the Value from column B - (in the cell to the right of A.) in to column N. I have tried the following, but it does not work.
=IF(A2:A202=M2,B2:B202,"")

Thank you

 

[Sal Paradise]

Try this:
=IF(COUNTIF(A:A,M2)>0,INDEX(B:B,MATCH(M2,A:A,0),),"")