You're going to have to provide a better explanation. We can't tell what you
have and what you're trying to accomplish based on your request below.
If you're trying to identify whether a list of parts in column A are present
in Column B, then in column C you can just use the following formula:
=IF(ISNA(VLOOKUP(A2,B:B,1,0)),"","Part found")
That will at least tell you if the part in A2 is found anywhere in column B.
Like I said, though, I can't really tell what you're after.
