I had this question after viewing Create Autocomplete Drop Down List on Spreadsheet.
I tried using the SS you attached for the previous user to see if your formulas/setup works with what I am trying to do. I can attach my template to show you what I am trying to do. I had originally done this without any code as a work around and I thought that may be the issue, but it didn't seem to work when I implemented my list into your sheet either. I have a list of part numbers that is Numbers, Words, includes symbols and I need it to dropdown with the options that match according to what is typed so far. I've tried making sure I double click each time and different things to make it work but the dropdown doesn't always work. For example if you type (into column A under Item#s) 25-005 and then hit alt + down, it should show you all parts that start with that, and it doesn't. however if I back up and type 25-00 then alt+down it will show matches for that and then if I add the 5 back on, I can get it to give me the correct list of items. Then next if you try M180 and alt+down I can not find anyway for this one to ever pop up. I've tried sorting the list different ways, coverting all to text, I'm out of ideas. Is there a limitation to Excels autocomplete options when you are using text,num and symbols in the same list?