Using Vlookup or Index to find multiple values?

Hi all
Looking for some help in listing all detail relating to a part number. I have added an example I put together to reduce the file size and ran the first row on a vlookup but looking into it I think it needs an Index formula which I am not good at. Any help with an example on one or all of the rows would greatly appreciated.

Many thanks.

Try this in K3 as a helper column and drag down

Formula:

Please Login or Register  to view this content.

In D3 use the following formula and drag forward and down.

Formula:

Please Login or Register  to view this content.

See the file

Jose I'm still not sure how it work but it does.. Thanks for you're help and quick reply, this is now solved but I do need to get my head around it.