=Database!$B$5:$B$10
2. gen_addrs Formula:
=Database!$C$5:$C$10
3. Data > Data Validation > Allow: List In the Source, paste this formula:
=IFERROR(FILTER(gen_addrs, strname = C6), gen_addrs)