I have workbook that has two worksheets. The main worksheet has an option to select a field called account "name". This drop down list is looked up from the other worksheet. Once a description is looked up then it looks up the corresponding account # that is on the 2nd worksheet. However, the list that I'm working with has about 1,000 items and so it takes forever to search for an item on the list. I'd like to be able to click on the account name cell and have a pop up appear. It would be great if I could do this using something like the built in find option that excel has (Ctrl + F). I'd then like to be able to search using a keyword to narrow down the list and then select the item that I want entered onto the list. What should I be looking at to accomplish this? I've attached my excel sheet to make sure that I'm clear on what I'm trying to do.
thanks, Brian
Bookmarks