Learn how to use TEXTJOIN Function to return multiple matching results, which is something you wouldn't be able to do using VLOOKUP function.

TEXTJOIN VLOOKUP replacement
https://docs.google.com/spreadsheets/d/1UmMNJVgOWMa3QBDo9yeJyJQQ_FU5Bsxzzkm5nUO4P6U/edit?usp=sharing

Google Sheets
https://www.google.com/sheets/about/