Mutiple Values Return by a single Lookup Value

[Msaad1395]

Hi Everyone,

I am in a trouble with a logic in excel i want to get return a series of values form a single lookup value.
Screenshot will make it more comprehensive. 

[#2]

Please see this solution on
https://excelkid.com/vlookup-multiple-matches/#:~:text=How%20do%20I%20get%20VLOOKUP%20to%20return%20...
It may help

[#3]

@Msaad1395 

FILTER is the best function for this situation:

FILTER function - Microsoft Support