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.
Bu iş için 10 freelancer ortalamada $75 teklif veriyor
Consider it done. Check your PM for my bid details.
What you are looking for is possible in Excel using macros. Let me know.
excel expert would complete the job in record time.
Hi, Its done as per your requirement and additional functionality, plz see pm for full documentation. Regards.
Hi, i can make you small C# program which will do this task instead of Excel poor environment, thanks.
I am capable of completing this task. Just send me the word and I will get started immediately.
Yes, It can be done and I am ready for your project. Thanks