Autocomplete Drop-Down List - Google Sheets 

that last trick is really great! Thanks !

AAAAH! Thank you! This is going to save me so much time!

This Is very helpful , i have been trying to organize something like this for hours thank you very much ,

OH, Cleaver!! ❤️ You're brilliant!! Thank you!!

Excellent thanks. I’ll definitely use that technique! 👌🏻

The solution really impressed me... Not even see that coming

Really helpful. Thanks again for your videos, keep up the good work.

Wow... Great work.. Love your videos.. 😃 🔥🔥💯💯💯

Thank You, Very Much!

dude how do you not have more views or subs. your channel is awesome. thanks for the great tips

This is a very neat trick lol.

Great 👍 sir thanks 🙏🙏🙏

Freaking Fanstatic. I Love it

Thanks

thank you

Cool Beans, Teacher!!!

Super

Hi! Im trying to automate a dayly save of a cell to do a grafh, do you have a video about that?

THANK YOU

Great video. I am a new follower.

Can you please explain how to establish an expanding quotation sheet based on a costing tab as you enter a new item in costing sheet where the quotation tab expand automatically to product a ready to print or send as pdf quotation??

Thanku

Genius

Hi. When we enter the first three letters of the data and the drop down list contains only one value matching it, then is it possible to press tab key to complete the data from the drop down list ? Apologies for my bad English

sir google sheets can run script to search website in google or not?

can this work on offline documents? I'm thinking of implementing this as a template for our clients, but internet connection can be a concern.

Great solution. I have one additional question: Once you clear the data input in My List - Product columns, the list in Options is emptied as well. Is there a way to keep all the input in Options, regardless what happen in My List?

Excellent video. Thank you. Will you do a video showing how to auto fill only one cell that is to the right of the drop down with a number. When choosing a selection in the drop down it will fill the cell with only a number that corresponds to that selection. I need to be able to select a certain city in the drop down and then it auto fill the other cell with the mileage only. Once this is done, will this create a problem to sum the miles at the bottom?

You can use unique function for this method

Thank you. I learnt a new thing today. However, I was searching for tutorials make dropdown list so that when we select an option, the text on the next cell should change. I wanted to show the meaning of validation items.

What if i want My List in a different document? any ideas how to modify?

It's f*ing genius!

How do I do this but also have the columns to the right auto fill with additional data that is tied to the item from the drop-down?

Hi, do you know how to automatically formulas in google form input in spreadsheet? Example the input form from google form always make new colum(like insert colum) that's why my formulas didn't work. Can you help me sir. Thank you so much!

can we do this feature in Google forms ?

Awesome! But how do you delete duplicates on the options tab?

Is this possible for Google Forms? I'm stuck and can't find any solution. My plan is to populate a drop down using a google sheet. And then when user fills the form and starts typing, the matching options are filtered in the dropdown list. Thanks.

Where the cursor is, the column and row are highlighted. Please make such a video.

on this method how to avoid duplicate?

Ninja

skip to 05:48

Do you also host the Get __it Done! channel? Somehow you've usually got a video for what I want to do.