Excel data validation list based on another data validation list

preview_player
Показать описание
Here is how you create one data validation list in Excel based on another data validation list. Example: if you select one state, you only want to see the counties for that state not all 50 states.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
  1. Chris Menard
  2. data validation
  3. scb tv
  4. chris menard
  5. Microsoft Office Master Instructor
  6. trainer
Рекомендации по теме
Create data validation 0:05:10

Create data validation list from Excel Table... the RIGHT WAY!

Create multiple dependent 0:07:16

Create multiple dependent drop-down lists in Excel [EASY]

Easier Data Validation 0:01:00

Easier Data Validation with Dynamic Drop-down List in Excel

Excel Data Validation 0:00:31

Excel Data Validation #exceltips #exceltutorial #howto #tutorials

Data Validation in 0:00:36

Data Validation in Excel‼️ #excel

Advanced Excel - 0:13:08

Advanced Excel - Data Validation and Drop-Down Lists

Multiple Dependent Drop 0:00:54

Multiple Dependent Drop Down List In Excel! Learn this in one minute! 😎 #excel #exceltips

Create Data Validation 0:05:21

Create Data Validation List from Excel Table (3 Easy Ways)

Excel data validation 0:02:47

Excel data validation list based on another data validation list

Data Validation in 0:00:19

Data Validation in Excel ✅ Excel tricks and tips 🔥🔥 #excel #exceltips #exceldata

Drop-down list without 0:00:12

Drop-down list without data validation

Create Multiple Dependent 0:11:57

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Create SMART Drop 0:15:42

Create SMART Drop Down Lists in Excel (with Data Validation)

Easy Dynamic Dependent 0:07:20

Easy Dynamic Dependent Data Validation Two Ways

Excel Create Dependent 0:03:50

Excel Create Dependent Drop Down List Tutorial

Data Validation List 0:01:09

Data Validation List with Dynamic Arrays in Excel - EQ 95

Create list with 0:00:47

Create list with Data Validation

Data Validation Drop-Down 0:02:24

Data Validation Drop-Down List with Excel Table Dynamic Range

Drop Down based 0:02:34

Drop Down based on another cell | Dependent Data validation | Microsoft Excel Tutorial

Excel - Data 0:05:16

Excel - Data Validation with the INDIRECT Function - Excel Advanced

MS Excel - 0:04:50

MS Excel - Dependent Dropdown List

Auto-Populate Other Cells 0:08:04

Auto-Populate Other Cells When Selecting Values in Excel Drop-Down List | VLOOKUP to Auto-Populate

How to apply 0:00:50

How to apply data Validation in excel #datavalidation #excelformula #exceltraining #tutorial #excel

how to auto 0:00:15

how to auto populate cells with data in Microsoft Excel using keyboard shortcuts. flash fill feature

Комментарии
Автор

This was absolutely excellent, clear, no over-explaining, and exactly what I needed! Thanks!

haggardfalcone
Автор

Thank you so much! I was hard stucked for days on an error. Your short video made it clearer.

guillaumedoguet
Автор

Agreed! Just what was looking for and great simple example. Smallish side note - not directly related to this solution, but to the List data validation bit. Excel doesn't like special characters in list names apparently, error: ("...or type a valid name for the selection") Swapped them for underscore e.g.(SOW1_Name_of_Project) and can name a list with that. Thanks Chris

stimm
Автор

This is exactly, what I was looking for. Thanks.

bijo
Автор

You've just made my day. Thank you!

TSTE
Автор

Plan, Simple, Useful, Excellent, Thank you!

rachitchhabra
Автор

What if I want to add more states? Can I change the selection to include the additional state?

rodolfotofoli
Автор

Thanks so much, you just saved me a truckload of work :-)

youcanreachwendy
Автор

Thanks. I’ve wanted to do this for a long time but couldn’t figure it out.

fpt
Автор

Thank you. This helped me.!!

How can I do a validation for another cell with same value.

e.g. I have sale status as "Not Sold", "Blocked", "Sold" in Column A, In Column B - I need to define what type sale it is "Online" or "Pickup" and I need this to be displayed only if sale status is 'Sold'. for other sale status, I need to show "Not sold" or "TBD". I am able to solve this.

Now I need to define column C the payment status - "Paid" or "Not Paid" if "Sold" in Column A. else "TBD" or "Not Sold" to be displayed in dropdown. Any help will be appreciated.

urssayeee
Автор

I cant apply this to Google Sheet. I check Indirect(D2) and it gives same string. But Data Validation doesn't allow me to put the range as Indirect(D2). Sad. :(

quan