Thanks, that worked great.

I inserted a column in front of Column A and now i need to take the
list, that is now in Column B and look for a match in the list that is
now in Column D and if it doesn't find a match, then paste the words,
NO MATCH, in Column A next to the corresponding part number in column
B.