Excel Formula/Validatoin Help

[Spooner]

i have a user request forms with multiple inputs and data validation to lists as opposed to free form text.

can you include an if statement in the Data Validation lists to choose a corresponding list based on the value that is in the cell next to it?

For example:

Excel sheet:
last name, first name, layer of access, type of access

Lists:
layer of access [with values App, DB, OS]
type of access App [with values Setup, Transact, SuperUser, Inquiry]
type of access DB [with values Select, Update]
type of access OS [with values Read, Write, Execute]

How can I make it so that is someone puts a value of "DB" in the layer of access column, the list that they see in the type of access reads the values from "type of access DB"

not sure if all that makes sense, but i have to think theres a way to do this

 

[Anubis]

ask in programming

 

[Spooner]

Originally posted by: Anubis
ask in programming

seems a bit overboard for this type of request

 

[Nerva]

hahah, i thought you needed help on vlookup or something... way beyond me.

 

[mayest]

You can't use an IF statement directly, but you can certainly do it indirectly. Instead of typing in a list of choices, select a range on the worksheet. You can set formulas in that range that will change as the worksheet changes. So, the range for the second list will update depending on what is chosen in the first list.