Searching one list for items in another a bit like Vlookup - need help before I go bald!

I have a list of available parts in Column A

OPEL 4708241 4710944 93192978 SUZUKI 5531162J00000 55311-62J00
OPEL 4700711 9193872 SUZUKI 5531183E00000 55311-83E00
OPEL 93176389 93179462 SUBARU 5531184E01 5531186G02 SUZUKI 5531184E01000 5531186G02000 55311-84E01 55311-86G02 VAUXHALL 93176389 93179462
OPEL 4708241 4710944 93192978 SUZUKI 5531162J00000 55311-62J00
OPEL 4700711 9193872 SUZUKI 5531183E00000 55311-83E00
OPEL 93176389 93179462 SUBARU 5531184E01 5531186G02 SUZUKI 5531184E01000 5531186G02000 55311-84E01 55311-86G02 VAUXHALL 93176389 93179462
OPEL 4700711 9193872 SUZUKI 5531183E00000 55311-83E00
OPEL 93176389 93179462 SUBARU 5531184E01 5531186G02 SUZUKI 5531184E01000 5531186G02000 55311-84E01 55311-86G02 VAUXHALL 93176389 93179462

I have a list of AVAILABLE parts in column D
PART LIST
9193872
93176389


I want to perform a kind of V lookup to result in something like:

Available parts list 1 LOOKUP Result

OPEL 4700711 9193872 SUZUKI 5531183E00000 55311-83E00 9193872
OPEL 93176389 93179462 SUBARU 5531184E01 5531186G02 SUZUKI 93176389

I'm pulling my hair out!

Thanks

Maybe not most elegant solution but it's working...

That is a thing of Beauty! Thank you!

What do I change to make it return the next column along, instead of the part number?

All the best

What do you mean? All data is in same cell.

Apologies, I mean if we had PRICES in column E, how do i make it return those prices using that particular formula?

I know I could do it with a Vlookup, just curious!

Thanks again