Updating cells based selection drop down list data validation

Rated 4.36/5 based on 700 customer reviews

If you have done all the steps above correctly you will get the desired result.

If things are not working correctly for you just ask me below in comments to share the finished Spreadsheet. This way you can auto-populate information based on a drop-down selection in Google Sheets.

You can also use a formula that updates your drop-down list automatically when you add an item to the end of the list.

To remove an item from a drop-down list, at step 2, click Delete, select "Shift cells up" and click OK.

updating cells based selection drop down list data validation-41

updating cells based selection drop down list data validation-78

updating cells based selection drop down list data validation-66

But if the user selects Chinese from the first drop-down list, the second drop-down list contains the Chinese dishes.The functions are IF logical function, Unique and Query Function. You should understand what I meant by saying auto-populate information based on drop-down selection. Before starting, I want to make clear few more things. Similar to read: How to Properly Hide Sheet Tabs in Google Sheets.If you just want to display any single value corresponding to your selection, you can skip this tutorial because for that you can use Vlookup or Hlookup functions. How to Use Vlook and Hlookup in Google Sheets When you want to make a calculation based on a drop-down selection, the best way is to use SUMIF function in Google Sheets. Create a Unit Calculator Using Google Sheets Now back to the tutorial. Inside the Team Members sheet, type the information as below. You can do lots of things in a Spreadsheet-based on your logic. To fully understand the power of Google Sheets, you should go deep into it.I’m using here three Google Sheet functions and a Google Sheet Command. If you are not well versed in using this, do not worry. There is one important thing you should know before going to the tutorial section. I’ve just picked this sample as I created it earlier to answer one user’s query that I got online. If you understand the above concept you can continue to our tutorial to auto-populate information based on drop-down selection. They are Master Sheet, Team Members, and Team Name.

Leave a Reply