Create a dropdown list from a range of cells: Google Sheets: Data Validation

Here is a link to the accompanying post The Monster Guide to Data Validation in Google Sheets, it has more explanations and links to resources for you! https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

In this tutorial, we cover how a number of ways to create Data Validation dropdown lists from range data in Google Sheets.

NOTE! This is an updated versions of a previous video.

00:00 Preview 00:24 Creating an ordered dropdown list from a range of cells. 01:59 A list from horizontal data. 02:46 Create a list from a matrix of data. 03:50 Using relative and absolute values for dynamic lists. 06:49 Wrapping it up.

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace https://yagisanatode.com/2017/11/01/how-do-i-lock-certain-cells-in-a-formula-in-google-sheets/

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=f0kztZG3odo