If I understand your posting correctly, you are saying that you have
something like this in column A:

1234
567
8914
23456

i.e. part numbers - you do not state if these are in order or if they
follow a particular format (eg 6 digit). In column B you have text
which contains the part number, something like:

1234 wheel
567 passenger door
8914 headlamp
23456 rear bumper

Again, you give us no examples of what this is like - are the part
numbers always to the left, or can they be embedded within the text?
Are they always separated from the text by at least one space?

If this is a fair description of your problem, then VLOOKUP won't work
on its own. But, in order to give you some further help you do need to
describe your data a bit more fully with examples.

Pete