Google Sheets Drop Down List - Data Validation Tutorial, Dynamic Lists from Ranges

Video tutorial about creating Drop Down List in Google Sheets using Data Validation. You will learn how to make drop down lists from ranges and make them dynamic.

Google Sheets

Website:

[JamesMoscovar]

Excellent!, is there a way to add specific prices or values instead of average?

[LyenFish]

Exactly what I needed to know, thanks!

[anonymouswikileaks]

Thank you for another helpful video. I would like to know if I can do sorting with dropdown menu based on another criteria like record created date

[headoffice]

Thanks you it is very helpful full and i do have one question please can you help me thanks if item is out of stock then remove item from data validation list

[udhayasankar]

Thanks sir your teaching super sir Tamil languages ley speech pannina romba usefula irukum sir

[BalooloBlue]

Thank you, your videos is helpful, could we make Data validation link from another sheet file?

[Rechka]

Hello can we protect validation data from editing by my team ( like locking the validation )
and let them only to chose ?
thanks for alll your efforts

[ahmadin]

Can you make the "category/type" with choice of price? For example product A, you can choose price 1, or 2, or 3 dollars. And product B with different price 4, 5, 6 dollars., ?

[paulkridakorn]

Thank you. This is very helpful and it worked.

[tere]

I have a list that is 800 lines long. Can the list be made searchable? For example, I am looking for Jane Green. Is there a way to type in "een" and get all the names with "een" in them?

[ronyjoseph]

@Learn Google Spreadsheets thanks for the video, is it possible to get dropdown from another worksheet directly?

[Gamesofmach]

Helllo. I want to create dropdown menu wich will change certain text/words in the other cell. I tried to combine INdirected cell with neighbor cell to solve this problem. but it saves only left top cell. I need to combine all texts to make it one click-mark-copy-paste in other place. I Ihave long sentence where some words are vary, you have to change them depending on your needs, I want to make it easy by dropdown . Can you advise what functions or tools should I look for on youtubeor maybe some of your videos to find solution for this task> Its to long to watch all your videos.? Thank you for your work.

[acrosstheunitedstates]

Can we have those demo datasheet links on the video description

[learningstuff]

Is there a way to do a drop down data validation list, with a list of images? Example: =IMAGE("URL")

[agahariiswarajati]

how to make data validation load faster when there are many name on data validation? thx

[jupiter]

how do I find the percent that one of them is, for example, my drop down bar is complete and incomplete, how can I find the percentage of what’s completed and have it update every time I switch one from incomplete to complete

[yumirubi]

is there a way to stop from entering a data twice if the info is coming already from a data validation?
If i can get any help i would really appreciate it!

[baburrashid]

Hi There,
Is there an option to get all the prices for a specific category, instead of getting average price??

[nikipaliogeorgos]

how do you make a drop down list with the ability to choose more than option in the list. for example in your video what if the person wants to choose Product A AND Product B

[riqueav]

I'm having a problem. In a Excel sheet there is a cell that have a formula AND data validation (if the conditions are not satisfied, it will remain blank and the user will choose an option from the dropdown list, If It is necessary). I'm converting this sheet to Google And It seens not to have this possibility, cause once there is a formula already writen, the dropdown list do not open. Can you help me, please?