Pop Find and Select item to insert

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.

Beceriler: Excel, Visual Basic

Daha fazlasını görün: excel find select, keyword find, uses for excel, excel uses, select, select item from, d to, window excel 2013, 2013 excel visual basic, excel 2013 visual, excel search multiple keywords, select drop, multiple keywords excel, excel window, visual basic excel 2013, excel search keywords, drop menu excel, excel drop, excel 2013 visual basic, select name, name select, account list item, find multiple, item list, select select

İşveren Hakkında:
( 2 değerlendirme ) ALPINE, United States

Proje NO: #4422071



Excel expert. Definitely possible. Please see your messages. Thanks

1 gün içinde 35$ USD
(63 Değerlendirme)

10 freelancers are bidding on average $75 for this job


Consider it done. Check your PM for my bid details.

in 3 gün içinde99$ USD
(51 Değerlendirme)

What you are looking for is possible in Excel using macros. Let me know.

in 2 gün içinde75$ USD
(82 Değerlendirme)

##### Excel expert here! Please check PM. #####

in 3 gün içinde82$ USD
(37 Değerlendirme)

excel expert would complete the job in record time.

in 2 gün içinde82$ USD
(14 Değerlendirme)

Hi, Its done as per your requirement and additional functionality, plz see pm for full documentation. Regards.

in 0 gün içinde35$ USD
(7 Değerlendirme)

Hi, i can make you small C# program which will do this task instead of Excel poor environment, thanks.

in 3 gün içinde100$ USD
(5 Değerlendirme)

I am capable of completing this task. Just send me the word and I will get started immediately.

in 3 gün içinde110$ USD
(0 Değerlendirme)

Ready to develop your Excel project.

in 7 gün içinde110$ USD
(0 Değerlendirme)

Yes, It can be done and I am ready for your project. Thanks

in 3 gün içinde66$ USD
(0 Değerlendirme)

I would like to offer my services for this job.

in 3 gün içinde65$ USD
(0 Değerlendirme)