IF criteria is matched than return value of another cell ***HELP***

[udfxrookie]

I have a table of 300 records of name, number, address, fronter, closer, etc.... then a record of just phone numbers of sales already entered (375 records).
I take the workbook with all the data and create two additional columns (A and B) and insert all the phone numbers of sales already entered into column A. In column N resides the phone numbers of new sales I need to compare and in column d is the fronter. Here's what I need:
Column B needs to have a formula that compares record N2 to all the numbers of sales already completed $A$2:$A$375... if it finds a match it needs to return the value in D2 to B2

 

[udfxrookie]

To make things worse there may be a space in front of some of the numbers in column A... there are absolutely no "white" or blank spaces in column N that it's being compared against though.

 

[Marcelo Branco]

Maybe

B2
=IF(COUNTIF($A$2:$A$375,"*"&N2&"*"),D2,"Not Found")
copy down

M.