Excel Tips - Create Searchable Dropdown Lists | No VBA or Formulas Required | Latest Excel Versions 

Thank you so much =) really appreciate it

Hey there, I made this video showing how to leave only certain cells unlocked. Try this on the searchable fields and let me know if this helps ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FhpkLchk3L8.html

Hey yes! You can do this without coding.

Thank you for commenting =)

Thank you so much!

Which version of Excel are you using?

​@@CareerSolutionsforToday latest one

Thank you for the comment. Did you testing usinh it with numbers? It should work the same. Let me know =)

@@CareerSolutionsforToday no not working

@@Kadapakuwait44 Hey there, did you set the formula up to filter by your account number column as well? I tested on my end and works ok.

@@CareerSolutionsforToday bro please help with this how to do i need it , i am struggling lot

@@Kadapakuwait44 Can you paste or copy the exact formula you used in your Excel here? That way I can take a look =)

It has been established in the latest versions of Excel. I am currently working on 365 =)

Hey there, which version of Excel are you using?

@@CareerSolutionsforToday 2016

@@techvehicles2467 This is a feature in the latest versions of Excel.

@@CareerSolutionsforToday I am in LTSC ver and it isn't there

@@madjayax731 I am sorry to hear that, not sure why it wouldn't be working.

Hey there, which part is not working?

@@CareerSolutionsforToday bro i had entered 1850 items in my list list scrolling is working but not text type search im using office 2016

@@dmnjeetsingh1 Gotcha, sorry for the confusion, this is available in the latest Excel versions.