Excel: VLOOKUP with cell containing multiple references

I have a table which contains multiple references per cell separated by a blank space.

In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the component which is linked to each reference.

Here is an example of my first table:

And here is the result I'm trying to achieve:

Use VLOOKUP of the reference to get the component name in the first table.

I cannot get it to work as the number of references associated to a component is not constant.

Recent Questions...