I'm made a serchable dropdown menu in excel similar to the one in this link( https://m.youtube.com/watch?v=vkPoViUhkxU ) what I can't figure out is how to make 5 dropdown menues they all need to be searchable from one database/list of customers I have on a spreadsheet. If I link all of them to one list, when I search on one menue the next menue can't serch other customers except the one I chose on my last menue . I need to be able to search and choose a customer on 5 different menues That get its list from one database or list I will be adding more customers to the list so I can't have 5 different lists

Thank you in advance