Create a Searchable Drop Down List Just Like Google - Excel Trick
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- Create a searchable drop down list in Excel just like Google. This trick is fantastic for large lists. Giving the functionality to search within a list goes beyond a standard drop down list.
I have a newer version of a searchable drop down list which is much easier here - • Searchable Drop-Down L...
Master Excel today with this comprehensive course - bit.ly/Ultimat...
This video tutorial will show you how to create a combo box control on a spreadsheet and then use formulas to create a dynamic searchable drop down list.
This list would look awesome on your Excel dashboards and reports.
The video covers multiple Excel formulas and functions including INDEX, COUNTIFS and ROWS. It then uses a simple line of VBA code for the drop down combo box.
Subscribe to this channel to see more awesome Excel tips.
Find more great free tutorials at;
www.computerga...
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
You can now create a searchable drop-down list much easier with the FILTER function. Check out the new and improved video - th-cam.com/video/Ea_ACp5W8zI/w-d-xo.html
Great work sir, thanks for the effort :)
I dont see the filter function in my o365 :(
@@abunasar786 same problem, seem like only in Insider Fast update channel
I don't have to new office 365. I'm working on excel 2016. And this video helped a lot. But i am having one issue. That combo box we created keeps popping up
Great tip! The detail with VBA line was fantastic. Thank you!
This is what I am searching for a long time and Thank you very much for your excellent support. ThanQ
You're welcome, thank you.
Thanks a lot, I did follow your instructions in the web you have given also use some other tutorials when I get struck, now it's working perfectly. Thanks again for your great support extended.
Fantastic to hear. You are more than welcome Cyril.
I love this but I need to use it on multiple rows in a column...i use data validation with list but I really love the way this narrows down the list results
Thanks Tim. I don't have a version that works with Data Validation, but there are examples I believe out there.
@ComputerGaga speaking to this subject, is it possible to link a vlookup function, so that after you use your search engine to enter a particular name, multiple rows will populate with values from the name you found in your search engine?
Thank you sir. Perfectly presented. Extremely helpful.
You're very welcome! Thank you.
Hi computergaga, thank you for the great tutorial. I have one little problem though, maybe you can help. My dropdown box does not come with a scroll down feature, meaning that when it should have a long list, part of that list is simply not shown. Do you know my problem, and how should I fix this?
Brilliant! A thousand thanks!
You're welcome Chris.
So I have another process I'd want. If it even possible. Lets say the first would be customer number, once that account auto fills the rest of the information about that customer (Address, Contact etc), I then want to have another cell that has a pop-up calendar view of month I can pick days to schedule the customer but that pop up calendar for that cell would always start from "TODAYS DATE" meaning actual dates. but also capable of exporting those I inputted to my google calendar without errors. (which I know how to export from excel). Hope It makes sense and you are able to work your magic. thank you. I love your videos. you are great in teaching people like me who knows only basics of this. Keep it up.
Hi, this is very helpful! Is there any way to prevent the users text to remain in the combo box if it does not match anything in the list?
This appears very useful. I am having a problem in that each time I click either into the Active X Combo Box, or the drop down arrow on this, the font size increases until I can no longer see what is being typed. Is this a common problem? Is it perhaps to do with the default settings for the combo box? I would be grateful for your advice...
Dear GG, thx for this comprehensive explanation ! I just have one issue if I implement this , the Dropdown Menu keeps popping up every if I change input in non-related cells ? Do you have more tricks in your magic case ? Thanks & Cheers , Johannes
Nice Solution - thanks for this. One weird issue, if my worksheet is locked, the full dropdown list does not show when the combo box is empty. Is this a known issue or do you think there's a problem with my sheet? (I've thoroughly checked all the formulas and everything apart from this feature works perfectly.)
Great work, TY. but how can i link the search box from a clean sheet to another sheet?
Thanks for this walkthrough, great stuff. I just have one query: at the very last step, when i type in a name in the combobox it only shows 2 names in the dropdown no matter what I type, and there is no possibility to scroll either. What do I have to do so that the dropdown shows all the available names containing the text i typed (like it does in your video)?
Having the same problem, when I first created the excel it worked fine. But for some reason it doesnt anymore. I have changed the excel version so it might have something to do with that.
Hi Alex, were you able to resolve this? Even I am facing similar issue
Great video! One question - once I put the defined formula into the linked cell range when I type in the search bar the search values are showing up multiple times in my drop down list. Any tips?
I found the this tutorial extremely helpful thank you! I did have some trouble with the dynamic range for the dropdown list as it would randomly repeat items and have empty spaces. I resolved this by just having the full range available, the empty spaces below were no trouble and it had the added benefit of the full list to be visible...
Really very helpful. Can you help what reference to put in LinkedCell if reference file is on another sheet.
I was able to use your tutorial and make it work on an item list of my own. Thank you for the step-by-step tutorial. It worked perfectly. I was just wondering if it would be possible to use the combo box across multiple rows. I was hoping to apply this same concept on an item requisition form or order form. Any tip would be of great help. Thank you!
I guess so, but they would need their own cell link and column. You may be better looking for a VBA version of a searchable list.
Thank you for the advice! Cheers!
Dear Sir,
it's simply fantastic ....and very worth to work with, your help in this regards is priceless ..love you so much.
Thank you Siva.
Wonderful ! I can't wait to use that. Thx mate !
My pleasure.
thanks for a good video ;). I have a question for you .how can we do searchable dropdown list for unsorted list?
this is amazing!!! love it I will think about it and create one. Is there a way to do a search criteria and then pull a list of records? I just learned about (dget) formula for a record and it is interesting but only works for a single item. I guess I can do what i want using filters but if there is another way so that I can have a tab for enquiries that would be superb
With Microsoft 365 you could use FILTER, but in other versions VBA or Power Query is your best bet.
Thanks much! Super duper useful.. ☺️
Happy to hear that! 👍
I would like to create the searchable combo box in a form, not on an Excel sheet. When I created the searchable combo box in a form, the LinkedCell and the ListFillRange options are not available in the properties of the combo box that created on the form. Should I use VBA code to assign the value for LinkedCell and ListFillRange of the Combo Box on a form?
Thank you for the video, very informative, the only challenge i have is when i try adding my named range to the ListFillRange, as soon as i hit enter it removes my input, I have tried to check some other forums and they suggested I uncheck my R1C1 reference style and even once that's done it fails, please may you kindly assist if you have any more magic tricks in your hat
I'm having a couple problems with this. First of all, amazing tutorial! So well explained and easy to follow. After basically copying everything you've done step by step I'm noticing that right now my dropdown box is only displaying the first 14 results. In my properties I've got ListRows set as 8 (which was the default and I haven't changed it) so I have to scroll down when there are more than 8 results but I can't scroll down any further than 14 results (and I've only typed an "a" in my search box and that should yield 405 results). I can't find anywhere in the properties that shows a max result value. I copied the formula for the "define name" selection exactly as you did in the video except I entered my end range value as $D$536 (which is the last row of my list). I should also mention that my searchable list (row d) populates fully, it just doesn't carry over fully to my dropdown. I also notice that when I type in a different search that yields less than 14 results (let's say it yields 8 results), the dropdown menu contains the 8 results and then 6 duplicates at the bottom for a total of 14 results. Or sometimes it would show the 8 results, 5 blank lines and then 1 duplicate result, still for a total of 14 lines. Any idea what's wrong? Here is my complete formula for the define name selection if that helps. =$D$2:INDEX($D$2:$D$536,COUNTIF($D$2:$D$536,"?*"))
The only thing I've done differently from your tutorial is that my dropdown box is placed on a different sheet from where all the formula action is going on, but I don't see how that can matter.
The other issue I'm having is creating a second combo box. I basically want to have a spreadsheet that has a section for items with 5 dropdown menus so the user can select 5 items hailing from the same list. The first combo box functions great (aside from the 14 lines issue) but when I create a second combo box in the cell below the first one, it goes all crazy when I type anything into the search box. I've renamed it combo box 2 in the properties and my coding also reflects the name combo box 2, but when I start typing three letters in the search box it accepts the first letter then jumps to combo box 1 and enters the first and second letter, then types the third letter in a random cell. I've tried linking the second combo box to a different cell (E2 instead of E1) but then my column B formula is wrong because it has $E$1 in the search function. So do I have to create a new column B, C, and D for each combo box I want on my spreadsheet? Any advice anyone can give me would be much appreciated!! Thanks!
Hi Megan
I had the same issues as you, but with 20 instead of 14 results, the repetition i solved the repetition problem using the function COUNT instead of COUNTIF. Did you fix the nr of results to scroll bug?
Thanks!
I have the same issue with the blank spaces and then repetitions. Plus, if i scroll up and down the dropdown list, the list changes the position of the duplicates. glitch?
Wow! That was an awesome tutorial.
Thank you.
Does this searchable drop down list work with multiple dependent drop down lists? I would like to incorporate the two of them together in one document.
Hi great video but I need help with 2 things. First I made the drop down menus but when I go to print it still shows the drop down menu arrow and box. How do I get rid of these?
Second I would like the drop down menu that appears when I start typing a name to be a bigger size. How do I do that?
Excellent video
Thank you, Aston.
This is a really great function, and it was just the function I was on the lookout for my VBA project, and I got olmost all of it to work, but for some reason I can olny click on the first searchresult in the combobox, for the combobox to write the value to the specified cell, all others return a empty value.
I am pretty sure it has to do with the ComboBox in VBA, but is there anyway to get the combobox to return the value i clicked on?
I have everything working up to putting in the RangeName in the ListFillRange. Anytime I put it in, it'll just clear out that field.
Double check that the named range definitely exists.
@@Computergaga Yeaaa It looks like I fat fingered it and clicked a cell while filling out the formula that goes into the range name. Got that part figured out.
I did run into an issue where if you search for the first part of a name it'll only show the very first result. I can hit delete to clear out the rest of the name it listed and it'll show the rest of the findings. But that's a bit unintuitive for the user I'm building this for. I tracked that one down to the "If Found" column. It seems to work find if I search for something in the middle of a name though.
@@Computergaga I'm trying to figure out now how to apply this to all cells under a column. I'm building a file to populate asset details and user data and this is going to be used to make all the Locations and Sites easier to type out since we have well over a hundred.
Each row is going to be a new asset, so the person populating this worksheet will be working downwards. How can I apply this ComboBox to each cell so when the user clicks on the cell or tab or enters onto it they can just start typing out the location they know?
first of all, thanks this is amazing, but i have a problem, when i type something in other sheet and press the arrows (or not always, its a bit random) the drop down list appears and its very annoyng, any solution?
what a beautiful red stone contraption
Thanks alot 😃
You're welcome.
Hello, I have a problem I have tried you formula but from the beginning it goes wrong after I made the dropdouwn list and made a reference to the cell above, now I bring the formula: search ($ G $ 1, B2) I get # N / A, what am I doing wrong?
Great video! Is there a way to create multiple drop down search boxes in one excel workbook page that are independent from each other but still pull from the same lists?
im using excel,2010. when i did this dropdown list exactly what you did in video, my file,crashes everytime i open it. what tlis the problem you think
very useful video
Thank you.
Google lists the word but can also autocomplete it. Is there a way to autocomplete it? Thanks.
There is not this functionality in Excel unfortunately.
Is there a way to fill this down - I need this drop down on at least 50 rows
Not that I know off at this time. I need to work on it.
very nice
Thank you Ariel.
Amazing video, this was what I thought I needed. During an isolated test, it worked exactly as advertised until... short version...is it possible to enable the ability to use TAB or ENTER to move between fields set up using data validation and ones set up with ActiveX controls as in the video? Long version...I set up a data entry form (my term, not Excel's) using data validation rules utilizing dropdown lists. Unlocked the appropriate cells, turned on protection and TAB/ENTER moved me from one field to the next. But one list has almost 400 possible values. I didn't like the way that list behaved. Your example was just what I was looking for. As I mentioned, a test worked perfectly. But when I tried to add the ActiveX control to my form, replacing one of the "data validation" fields, I could not get that field to be included in the data entry field rotation. In other words, can the two types be mixed or do I need to recreate my form using all ActiveX controls and be able to TAB/ENTER between them?
I'm not sure if this is possible as a setting in Excel I'm sorry to say.
Computergaga thanks so much for the reply. Let me ask one more question before I take the time to redo them all as ActiveX controls. If I do will Excel let me tab through them?
You can set a tab order for combo boxes on a userform, but I do not believe there is a setting for combo boxes on a worksheet. Unless you set up code using SelectionChange events and stuff.
Excel assume you will be tabbing between cells on a worksheets (like Data validation) and appear to have set up no functionality for tabbing between combo boxes on a sheet.
Anyone try this searchable list with part #s (I.E. 1234TV-34)?
I followed the tutorial and it seems to work.
But, is the next step to copy/paste the combo box onto my sheet I want combo search box to appear on and then link it to my data table column range?
Thx
thanks a lot :-)
My pleasure Islam.
mantap bossq
I tried to define the ListFillRange with the name , but when I gave an Enter, the name disappeared from the properties box. I cannot see what i am doing wrong. Can you help me out?
I'm not sure Henk why that would happen. Sorry.
I had the same problem and then I checked the last formula one more time. I had written a ";" instead of ":" after I changed that it worked. =$D$2:INDEX($D$2:$D$40;COUNTIF($D$2:$D$40;"?*"))
Thanks for a great tutorial!
sir, when i reopen the excel there is no automatic dropdown working, i need to write combobox1.dropdown every time....please help ?
Are you saving it as a macro enabled file Deepak? Sounds like you are losing the macro/sub.
@@Computergaga I am having the same problem and I did save it as macro-enabled. What else could be going on? It works perfectly and then when I close it and re-open it, it no longers works.
How can I make it case sensitive?
how to make this function case sensitive: =IFERROR(INDEX($A$2:$A$339,MATCH(ROWS($D$2:$D2),$D$2:$D$339,0)),"")
The Exact function can be used to ensure a match is exactly the same including case. I have an example of it being used with INDEX and MATCH here - www.computergaga.com/tips/lookup_formulas/case_sensitive_lookup.html
Thank you for your prompt reply, but this function come with IFERROR
Once i add in the true and exact the function does not work
May i know how will you modify this function?
=IFERROR(INDEX($A$2:$A$339,MATCH(ROWS($D$2:$D2),$D$2:$D$339,0)),"")
Or where should I make change for the searchable drop downlist as my product has both a and A. I would like the excel only detect the A
YES GOOD BUT YOU USE COMBO BOX AND COMBO BOX FILE WILL BE SAVED IN MACROS TRY TO MAKE WITHOUT COMBO BOX SEARCHABLE DROPDOWN LIST LIKE THIS
Brilliant. Now if we can only fixed it in a cell like a validation data. This would be supreme.
Has anyone figured out how to do this?
I believe putting a table for the Array would solve the validation. Wouldn't it?
Great tutorial, great clear presentation, works perfectly! One problem I have and banging my head for answers is how can I copy and paste to create several search boxes without duplicating the answers to those search boxes? For example, I have copied/pasted 10 search boxes that need to have different answers using the same long list of locations. When I finally select a location in one search box it automatically replicates that location to the others. Is there a solution to this? Your help on this puzzle will be very much appreciated...Many thanks.
Would like to see an answer for this too.
Working on Excel along with the video. Up to this point I like the tricky fxn.........
=--ISNUMBER(SEARCH(). Thank U.
great tutorial!
how to create a combobox on every cell in a row? so if i want to input a data in a cell it shows a dropdown list of items?
thanks
did you find a solution to this issue?
Hi Computergaga, great tutorial. One issue that I've run into is that whenever i press enter in another cell on the same worksheet or another worksheet the drop down list appears and floats in that position on the screen. I know others have run into this issue but I haven't found a solution. Hoping you may be able to shed some light, cheers.
@computergaga I also have the same issue. No idea how to fix it
I have the same issue. Did you find any solution to that?
Thank you so much for the excellent video, I love it. I followed your instructions and my ComboBox works perfect; however, it pops up on other sheets within the workbook. I saw here in this page that some others have the same issue. Do you possibly have any solution for that?
how do we use it if there are multiple data validation and we want to use the names in multiple cells? for ex: I want to print Andra Fonseca in H2 and then sergio Gutierrez in H3 and so on. So how do we do that? Also for ex, there are data validation in the same sheet for Names and fruits and the list is big. How do we make sure that it works on both the data validations?
Watch this th-cam.com/video/dDPwq4REZac/w-d-xo.html
This is ridiculously useful, thank you!
tHE COMBO BOX WORKS GREAT, HOWEVER IT KEEPS POPPING UP ELSE WHERE ON PGE WHEN NOT SELECTED
I have the same issue. Did you find the solution to that?
Yesterday at 12:58 PM
Add bookmark
#1
Hi,
I have a combobox on a worksheet named "INPUT GUIDE" that is using data from another worksheet named "DATA TABLE". The combobox works fine but if a go into any other woksheet and press enter the combobox pops up. The code I have for the combobox is:
Private Sub ComboBox1_Change()
ComboBox1.DropDown
End Sub
Any guidance will be greatly appreciated.
Regards
Tony
Hello Computergaga, a great video and I am looking for a long time to implement something like this. But I need your help.
I implemented your video step by step, but in the "searchable table" only the first match is shown. Here is my code: =IFERROR(INDEX($B$4:$B$198;MATCH(ROWS($D$4:$D5);$C$4:$C$198;0));""). My first table entry (name is at cell B4 and the last at B198. As I cannot find the mistake, I like to ask you if you can have a short look on it.
Help please. I can't get this to work. The last part that creates the list that you copy into the named range resolves as #VALUE every time. I have checked the syntax and it looks okay and tried to find a solution on Office Help, but to no avail. What am I missing? Here is my formula ... =Clients!$AY$50:INDEX(Clients!$AY$50:$AY$550,COUNTIF(Clients!$AY$50:$AY$550,"?*"))
Thanks.
At minute 21:33 when I press enter, I get #Value! not one of the names in Column D. I have checked my formula carefully and had a coworker look at as well. The formula is exact =$L$2:INDEX($L$2:$L$78,COUNTIF($L$2:$L$78,"?*")) obviously my data is in different columns and I only have 78 lines of data, not 88 but that shouldn't matter. Do you have any suggestion for me?
Very strange behavior when I use this technique. I type b in the combo box and it immediately auto completes out to one of the items in the list starting with b. Example: bamboo tablet with the "amboo tablet" part highlighted. It's like it is auto completing the first selection it comes to in the array. The only way I can get a good search result is to press the delete key when it tries to auto complete which erases the extra stuff I didn't type. Very strange. Plus, if I turn off auto complete in options, it still auto completes in the combo input box???? It's not doing that for you in your video but it is for me.I just found another bug. I type c and it immediately displays one single entry that contains the word 'cabinet' in it but my cursor is inserted between the letters of the first word in that item. Continuing to type creates a jumbled search request that I did not type. How do I stop excel from displaying list items inside the search box? OK, got it working by changing the "match entry" property to "2". Yours is set to "1" so not sure why yours still works. At least it works now. Very happy with how this works.
Hi, i m getting similar issue . please gude me to fix it.
i'm having the same issue where I have to press the delete key to stop the highlighting...any way to fix this?
I had the same problem and I solved it by changing MatchEntry from 0->2 (fmMatchEntryNone) in the properties of the Combobox.
super. Thanks. i was trying to deactivate all the autofill and autocomplete excel options, but it was not working. The fmMatchEntryNone did the job :-)
Same problem. I have rebuilt my spreadsheet 3 times looking for "my" error.. Thank you so much
Hello! Thank you so much for this! I just want to leave this in case anyone has the same problem. I had other buttons on my sheet that made the combobox dropdown whenever I clicked them,
Instead of combobox1.change, I used combobox1.Gotfocus instead. It seems to have stopped it.
You're welcome!
You sir, are a life saver!
Thanks a lot for this video. This is something unique and simple way of implementing this. Have seen many videos but none answered to my question.
Seems i am asking a question after ages.
/** -Suggestion required for below task **/
But curious to know - How this combo Box will be cascaded/or each Cell in a row (Example:- i have a sheet where i want searchable Combo Box in each cell for range A:A then how the Combo Box will be cascaded).
Thanks in advance.
Wow that's a very nice result. I'm gonna have to try that. I think I'd like to make one that works for a whole column.
I found this incredibly informative. Really great work!
Thank you Russ. Much appreciated.
It's Good, but how to insert the data in the combo box, to fill a column, and what if somebody has multiple lists in a datasheet to fill. If you could help, you will be the best tutor ever, because nobody shares the real application part.
Hello from the beginning I get an error message, when I use the formula =search($J$1,H2), I get this error message; #N/A, how can I solve this?
Thank you for this tutorial! One problem I am having: my combo box does not have a vertical scroll bar so I am only able to see the first 7 results. Even after I expand the List Rows in the properties. Any help?
Have you found any solution for that ? It's been a year 😅
I have the issue right now
Same Problem, did u resolve it
Thank you for that video. Explained very well.
I have a list of 121 purchases that need to be assigned an account number. I use data validation but the entire list of account numbers-231-appear and I have to scroll through to find the one needed Then that account number goes to the cell, on the same row as the purchase, associated with the specific purchase. Is there a way to have a searchable data validation for multiple rows? I sure hope so. I’ve tried but nothing works.
Thank you.
BRILLIANT! This is just what I needed. Thank you so much!
You're welcome. Thanks Joseph.
A pure sweat saver. Just Excellent. You just gifted me "Peace" in my work by this tutorial
Thank you Asim.
Hello Sir. Please help me. I have success create this awesome searchable box. But, when it (file excel) reopen after saved, the drop down list was not function anymore. Why ya. Can you help me
Excellent, thank you very much. What needs to change if I were to search and add multiple values in individual cells down. For example if you have 87 records in the list and I want to search 10 unique values 10 times and add them down in rows individually instead of only one value as you showed in the video.
Exelente formulacion me ha funcionado al primer intento, solo tengo una pregunta cuando hago una copia del libro la lista ya no me despliega hacia abajo y no se como resolverlo.
My combobox is auto-filling the numbers. If I just want to type 3. It automatically types in 300. Why?? How do you fix that
I dont know why it is not working for me. My dropdown list only shows me the first result. I checked the formulars numerous times. I just cant see my mistake. And also when I enter a name to look up. It automatically fills out the rest of it and I cant delete it with backspace I have to press the delete button to change it. Can someone help me who maybe had the same problem here???
I was able to recreate everything in the video. I was presented though where the dropdown box only shows the first 5 items in my searchable list. How can I get it to show more?
Thx for a good tutorial. Question.... when I try to use the =Search I receive a strang error message >> www.screencast.com/t/o5aCI75zntUs telling me that there is a problem with this formula
Any one who recognise the error message and knows what to do?
Awesome tutorial! I do have a bit of a problem. My dropdown is showing all the blanks below the list.
Mine too. Would you able to fix it?
Hi there, how would you perform the search if the searched text may be in any cell within 5 columns (A to E). Would you concatenate A through E and then search in the concatenated result?
It has taken me about 3 days to finally figure this out! But it is amazing. Fantastic Job!
Thank you Joshua.
that's handy, assuming you know what the sentence or name etc starts with. could it be made to find Alejandra Camino or others with the last name Camino were you to start by typing Camino?
Thank you Maxene. It does already work like that. In the video you can see that when I type "th" it returns not just Thomas Hardy, but also Elizabeth Lincoln and Victoria Ashworth because they have "th" in their name.
I found the this tutorial extremely helpful thank you! I did have some trouble with the dynamic range for the dropdown list as it would randomly repeat items and have empty spaces. I resolved this by just having the full range available, the empty spaces below were no trouble and it had the added benefit of the full list being available when the combobox is empty!
Cheers.
Sir, do you know how to do this dropdown list, if I have to make more than 1 dropdown list, but the source is came from one? is this possible? can you create another video of it? many thanks!
Thank a lot for this usefull video this is actually best explanation about the searchable dropdownlist for excel, but i have a question if i have a duplicated results on my searhed dropdownlist what sould ı do?
VERY HELPFUL.
I wish I could do this on a userform.
Any help on this please?
Done it for vba. really easy :) this is the link.
th-cam.com/video/b6GJZs0NLqY/w-d-xo.html
Thank you for this great information. Whatif we need to comboboxes on same sheet? i did so, but second box opens first box's list :(
why private sub combobox1_change() is always called when i change other cell? is that normal?
How can you have the cells accept only what is in the data validation only? What I am referring to is, if you type a word in the cell and don't use the drop down list then that word will remain in the cell even if it doesn't match the validation list. How can that be avoided, how can you not leave a partial or other word that is not in the data validation list?I hope that is clear
excelent, in my case if i like to use only keyboard en down arrow key this is not working because the value of listbox change then in my list only 1 item. if yoy know how to resolve this please tell me. thanks
This is great, but how do you create a combobox on every cell in a row? so if i want to input a data in a cell it shows a dropdown list of items?
creating a new list of items from our searchable list of items
Hello Sir pls its there a way to kind of make the items in the dropdown list sensitive so that when you search for a name and it shows once you click on it carries you you to its position in the list....Pls help guys
Brilliant..
But i have more than 10000 search data list,so it takes more times and loading..
Worth a "Subscribe" click. Thanks.
Excellent. Thank you Rahul.
I have created this combo box but I am getting four items in the list rows and do not have any scroll bar on the right side. How to fix it.
wow.brilliant. beautiful video. worth to watch every second of this video. GBU.. thanks for sharing
You're welcome Haider.
Pukka video, enjoyable learning from you. I am wondering if you can use this drop down to produce contact details from a vlookup, I’d like to create a sheet that looks up customer account numbers using a drop down ? Can I?
Absolutely. The drop down pulls up the account numbers. Then a VLOOKUP for each contact detail.
Hi there, really nice tutorial. I don't get though how at 21:50 the result became the D6 value? The Countif gives 9, the INDEX part gives last entry which is the D10 value of 'Renate Messner' so the whole formula becomes '=$D$2:Renate Messner'. I'm soo confused please explain