How to☝️ Set Up Data Validation Based on Another Cell in Google Sheets

To set up data validation based on another cell in Google Sheets, click on the cell you need, move to the Data menu, select Data validation, set the cell range for the data, then check the box beside Show dropdown list in cell. After this, choose the Show warning option and, finally, press Save.

In this article, you will learn how to create data validation based on another cell in just a few seconds. Check out the article below and use the step-by-step process to see how it works!

What Is Data Validation Based on Another Cell in Google Sheets?

Google Sheets’ data validation based on another cell is a function that allows you to specify certain responses for a cell. These responses are usually presented in a dropdown list, and the user selects the desired option from the list provided. 

This can be helpful in ensuring that only valid data is entered into your spreadsheet and can save you time in the long run by avoiding having to clean up incorrect or invalid data later on.

How to Quickly Create Data Validation Based on Another Cell in Google Sheets

Below you will find detailed instructions and illustrations that will guide you through the process:

  1. Select the cell where you want the dropdown list.
  2. Go to the Data menu.
  3. Pick the Data validation option.

How to Quickly Create Data Validation Based on Another Cell in Google Sheets

  1. Enter the cell range you need to display in the selected cell. This range contains the options for your dropdown list.
  2. Check the box next to Show dropdown list in cell.
  3. Pick the Show warning option.
  4. Lastly, hit the Save button.

Data Validation

Voila! Your list is now ready.

List in the Cell

Let’s take a look at how it works and see what happens when we use it.

  1. Press on the arrow on the right side of the cell.
  2. Select the appropriate value.

List in Google Sheets

Easy as 1-2-3! Your selection will be displayed in the cell.

Dropdown List in Cell

How to Remove Data Validation in Google Sheets

You can cancel this action and remove data validation if you no longer need the dropdown list. To do this, follow the steps below:

  1. Select the cell with the dropdown list.
  2. Navigate to the Data menu. 
  3. Click on the Data validation option.

How to Remove Data Validation in Google Sheets

  1. Press Remove validation in the box that appears.

Remove validation

Once you have completed these steps, the cell will still show the last value you selected. However, if you click on the cell, you won’t be able to see the list that had been attached to the cell before.

The Value in the Cell

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.