VLOOKUP multiple results in a drop down list

There are 2 columns:
1. Material
2. Supplier

My first input will be Materials (for which I have created a drop down list) and accordingly I would like that excel automatically gives me the supplier name.

if there is only 1 supplier for the material, a simple VLOOKUP will suffice. But the problem happens when there are more then 1 supplier as the basic VLOOKUP function gives the name of the first supplier.

How do I get a drop-down list within the VLOOKUP function for such cases when there are more then 1 supplier.

Attached is the file. the data validation sheet is created to store the data. the gate inward sheet is where I need the answers.

Also, if anyone could help with how to increase the font size in drop down list, would be appreciated.

Also, i have added vlookups function here, but could not use it as not much know-how of it.