automate a dependent list?

[sugarcoma]

Hey there,

I'm trying to make a dependent list auto populate based on the first selection. I understand how to make dependent lists. How do i make the list in column a, auto populate columns b & c based on a?

Example:
If column a is named Dept and lists: Science, Engineering, Communications, Vulcanism

and column b is named Lead and lists: JameTKirk, MontgomeryScott, NyotaUhura, Spock

and column c is named Alias and lists: captain, scotty, uhura, illogical

How do i make selecting Dept auto populate columns b and c with JamesTKirk and captain?

wish i could post the screenshot. hope this makes sense.

Thanks!
-s

 

[aniketbhanu]

Is it possible for you to use a IF formula in column B and C, to populate values based on value in A?

 

[sugarcoma]

@aniketbhanu IF might work... trying to think of what that would look like... thanks!