VLOOKUP returning multiple answers from table

Attached shows two ways you can do this (besides just using a filter to show results).

They are colour coded blue for method 1 and green for method two. Anything else (ie. data and lookup value) are used in both.

Blue Method:
This finds all results and displays each one in a new table row by row.

Green Method:
This finds all results and puts them together in on cell.


Wasn't sure which way you were after.
Let me know if you need anything explaining, no point having a solution without the understanding or you won't be able to apply to your own work.

Hope this helps