I have an excel sheet that uses a drop down menu in column D to select an account name. Once the account name is select then the adjacent cell (column D) looks up the appropriate distribution from another worksheet. The problem that I have is that there are about 2,000 distributions to search through in the drop down list in column D. What I'd like to be able to do is click on the cell in column D and have the Find window pop up like when you click Ctrl + F. I'd then like to search the list on the other worksheet using a keyword or multiple keywords. Once that is done then I'd like to be able to select one of the items from the list and have it input into column D which would in turn look up the appropriate distribution for column E. Is this possible in excel?
I've attached the excel sheet so you can see what I'm working with.