Data Validation Lists

[tbrynard01]

I have a category column that has several values - I would like to be able to change the list that displays based on the category:
My date table has the following headers and I have the varies lists for each categories set up on a different worksheet each as it's own table:
View attachment 23094

Data Sheet Columns

Category

Date

Description

Client

Behavior Detail

Any help will be appreciated. I used if to get behavior to list but don't know how to have do it to have a list when I use another category.

Thank you!

 

[tbrynard01]

There are the lists that I'm using as an example: Sorry didn't come through in the previous post

Categories		Behavior		EnvironmentalSafety
Behavior		Aggressive Behavior		Bio-hazard Accident
Contraband		Assault		Bomb Threat
EmployeeVariances		Elopement/Wandering		Evacuation
EnvironmentalSafety		Intentional Damage/Destruction of Property		Gas Leak or Smell of Gas
Fall		Intentional Self Injury		Infection Control
FireAlarmsandDrills		Other		Natural Disaster
Illness		Search for Missing Client		Use or Possession of a Weapon
Miscellaneous		Sexual Assault		Utility Failures
Property		Suicidal Ideation or Behavior		Trespassing/Unauthorized Visitor
		Suspected Theft, Anger, Profanity		Wild Animals on Campus
		Threat of Violence/Violence		Active Shooter on Campus
				Unsafe Conditions on Campus

 

[Fluff]

Sounds like dependant data validation, have a look here

How to make a dependent (cascading) drop-down list in Excel

See how to create multiple dependent drop down lists in Excel based on the value selected in another dropdown, how to prevent changes in the primary drop-down menu and make dynamic depending dropdowns.

www.ablebits.com

 

[tbrynard01]

I did look at that before I posted, but I'm either not doing something right, but on each line of the sheet the Category may change and I can't get it to pull up a different list based on the category

Essential it is only 2 drop downs, one where I select a category and then based on the category a drop down based on the category.

 

[Fluff]

Are the values in the Category list exactly the same as the named ranges for the other lists?

 

[tbrynard01]

Yes

 

[Fluff]

In that case it should work, what exactly do you have in the source for the dependant dv?

 

[tbrynard01]

=Indirect(a2) I am sure I'm missing something basic
Possibly in the way I'm naming them

 

[Fluff]

Is the category dv in A2 downwards?
Also is what way isn't it working?

 

[tbrynard01]

it is, so when I select the first category item, Behavior, the drop down list that appears is correct. But when I change the category to EnvironmentalSafety, I still get the drop down list for Behavior. Hope that makes sense