Very difficult formula, is it possible??

[garfiola]

I dont know how to do this, i think it is not possible

I need to match two columns, I can do that with vlookup

But when I match it I need to create 4 rows

Here is how it looks like

 

[taurean]

If you want to insert rows then you will need VBA.