How to Create a Dynamic Searchable Drop Down List in Excel 

You sir, are a GENIUS! Best solution yet for those without access to Dynamic Arrays in Excel 365. That too you have implemented it without any VBA/Macro or other such advanced functions that are difficult for non-experts. Beautifully explained and I just had to follow you step by step to get the outcome. Thank you!

A very useful video, thanks Kazi.While I was testing it I wasn't sure about the user experience of trying to use the lookup list without entering anything in the search box. ie if they just click on the scroll button on the search field then there is nothing in the list. So I modified my version of this formula =IFERROR(VLOOKUP(ROWS($J$4:J4),CountryOfOrigin,2,FALSE),"") I changed it to this =IFERROR(IF(MAX(CountryOfOrigin[Helper])=0,INDEX(CountryOfOrigin[Country],ROWS($J$4:J4)),VLOOKUP(ROWS($J$4:J4),CountryOfOrigin,2,FALSE)),"") So basically if there isn't a value in the helper column then it displays the full original list. Cheers, Richard

Great video. I had tried several different methods with no luck. This solved my problem. Thanks for sharing!

thank you for sharing this video very infromative and it ie easy to follow how to do dynamic searcheable dropdown list especially i am using excel with no filter in formula box.

This the close to solution what i got. Thank you. Is there a way to list all names before typeing?

Love You Dude.. Such a useful Tip. I was searching this for 3 days...

Hi sir was very very useful. Very informative. Thanks. It had the features of searchable, dynamic and multi .in others it was not multiple rows .Thanks

Good day, sir. followed your instructions and worked well. Thank you, sir; you are a genius!

very good, i was looking for writing my password DB, then have a search on a criteria like account name (unique) and then extract all relevant infor around this search. Worked well.

Thank you so much! you are a life saver. Been looking for this for a very long time.

So much helpful, I have been searching for this my whole day, thank you

Fantabulous... Felt that you are explaining in front of me. Using the filter function this helped, but unfortunately, it is available only with Office 365. Your tutorial helps me to find admission numbers through a searchable drop-down list...

Thank you for the videos. You deserve a big load of respect.

Thank you so much for this video It helps me a lot

Wonderful application and great tutorial.

Thank you so much for such a wonderful video.

Thank you very much. Very nicely explained. Can the list be sorted in alphabetical order? We have to give a space and then only all the items get displayed. While pressing the drop down without typing, no items are displayed. Is there a way to get over this.

Really thank you for your effort we really appreciate it. I subscribed to your channel

Great video! Could you kindly please let me know what your circular formulae settings are? (Max iterations and max change). Thank you!

Great Work Sir.

GREAT VIDEO

thanks for useful information

Genius,, thanks sir

Sir as you are using office 360 you dont take to use search formula. But can you tell for excel 21 how I can add search formula to the formula in the video. I need searchable, dependable and dynamic dropdown list for my balance sheet. Thank you

excellent sir excellent. no words

broo.. u are awesomeeee !!!!! thanks a lot..

THANK YOU SIR..... THANK YOU SIR, AGAIN....

VERY HELPFUL ...TQ

Thank you sir...this is great

How did you change B4 to @Names

Hi there, I have a question! Isn't this method going to trigger the creation of the "filter" each time you write anything in excel? I can see that this would be amazing a small file but have you tested this on a massive file?

you r simply great .... thank u

thank you !

Very awesome. Is there any way I can get sample of that file? Thank you so much.

Appreciated.

thanks

wonderful, your video helps, keep up the good videos :)

Hi. How to make it work if new row with data was inserted to the table? Lets say in a middle of the table. It dosn't show up in searchable dropdown menu. Helper row is missing formula then.

Hello, one question, does this also work with Excel 365?

Excellent

How about if I type multiple letters instead of only one letter when searching?

Sir, where is the formula, which you said, will be shared below. For lay people to follow this rather complicated formula, is bound to send in error. Please provide the formula in this column

I was on fire watching your video, but when I put in the OFFSET Function, the formula Spills Over. Result, the Formula Name is not accepted by the Data Validation List... Waiting for Office 365 to come with Multiple Search Drop Down Lists as standard, now...

How is the logic of max formula,in fact I know but here I didn’t understand the function of it,also my formula doesnt work,always show 1 value,in fact max formula reveals the maximum of different numbers,but here it sums and its cut by when he face the value of zero? You said its not about the version either but my formula doesnt work

Is it works in any M.S version ❓

can you give me a link to reducing data validation drop-down list tutorial

u r awesome ^^

Brilliant

When i add the Max formula with +1 the excel hangs

HELLO SIR, HOW CAN DOWNLOAD THIS FILE PLZ

thanks tooooooo

❤

Too Fast.. :( can't understand the formula.