Forum Discussion
Create Searchable Drop Down List for Table With Multiple Rows
Hi there, Tech Community newbie here so I hope I manage to explain what I'm trying to do accurately (and also hope that someone can point me in the right direction!). I used Leila Gharani (a grea...
MikeHarper2039 I recommend that you review the searchable drop-down lists example I created on an invoice template. I prepared in range(A17:A33) the drop-down lists to bring data from the Products sheet to the invoice sheet. Thousands of data can be searched in the drop-down list and the result is added to the cell.
Source,sample workbook here : https://eksi30.com/excel-search-in-data-validation-list-searchable-drop-down-list/
This is brilliant thank you! I didn't use the VBA code to sort a-z, i just used the table sort function.
My range formula: AllSites: =OFFSET(AllSites!$B$2,,,COUNTA(AllSites!$B:$B)-1)
My data validation formula: =OFFSET(AllSites!$B$2,MATCH($B9&"*",AllSites,0)-1,,COUNTIF(AllSites,$B9&"*"),)
My range formula: AllSites: =OFFSET(AllSites!$B$2,,,COUNTA(AllSites!$B:$B)-1)
My data validation formula: =OFFSET(AllSites!$B$2,MATCH($B9&"*",AllSites,0)-1,,COUNTIF(AllSites,$B9&"*"),)