Hello,
Your question raises several points :
1. You do NOT need help with Vlookup
2. What you are looking for is a feature called Autocomplete
3. The first step would be a Formula to generate your matches
4. A second step would be to populate your validation list
5. Are you planning to work with a UserForm or directly into a worksheet ...?