Vlookup - return multiple values in one cell

[Cruupet]

Hey guys, im very new to excel and its mind blowing me right now loll.
I could use some serious help lol, unfortunately i dont understand what my partner has already done.
I am happy ot teamviewer please just msg me in private and ill explain what i need via discord, whatsapp or in a text box on teamviewer

 

[Macropod]

Cruupet: Please familiarise yourself with the Forum rules (https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). Inviting people to take discussions off-forum via the private messaging system or otherwise is a violation of Rule 4.