Autopopulate drop down box

[peug417]

I have a spreadsheet which I am using vlookups. when I enter an item it will auto populate the product code into another cell. The content is also from a validated list, though has over 2000 products. is there a way of typing the start of a name to locate products that start with those letters?

 

[jorismoerings]

Hi and welcome to MrExcel,

It can be done but depends on the way you want to use it.

Take a look at this YouTube video which gives a pretty workout solution to do this: https://www.youtube.com/watch?v=vkPoViUhkxU
This video will explain how and works purely with the usage of standard functions.

If you're not afraid of using VBA, this will also help: https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/

 

[peug417]

Many thanks, the YouTube video has given me the answer to my question. I have replicated the examples, (learning more and more as I went on) before converting the process to my own sheet, which had over 8000 products to sort from. The whole thing was a learning curve and a challenge to complete, however I am pleased to say after a few hours tinkering it works to perfection.