How to Create a Drop Down List based on the Selection of a Different List?

[eDarren]

I am trying to create a drop down list based on the selection of another list, for example:

[Column A]
List A:
1
2

[Column B]
List B:
AX
AY

[Column B]
List C:
BX
BY

If I select 1 from List A in Column A, I want to be able to select an option from List B in Column B. However, if I select 2 from List A in Column A, I want to be able to select an option from List C in Column B instead.

How can I make this happen?

 

[SunnyAlv]

Like this ??

Formula on Source

=IF(G3=1,INDEX(B3:B4,,1),INDEX(B7:B8,,1))

 

[eDarren]

Like this ??

Formula on Source

=IF(G3=1,INDEX(B3:B4,,1),INDEX(B7:B8,,1))

View attachment 113046

View attachment 113045


View attachment 113043

Thanks for replying! Looks about right with the example I used, however didn't work when I tried it (possibly user error...)


In practicality, I am trying to achieve:

If:

Cell E19 on Sheet 1 = A, Cell E23 on Sheet 1 =Drop Down List from A1-A10 on Sheet 2.
Cell E19 on Sheet 1 = B, Cell E23 on Sheet 1 =Drop Down List from B1-B10 on Sheet 2.
Cell E19 on Sheet 1 = C, Cell E23 on Sheet 1 =Drop Down List from C1-C10 on Sheet 2.
Cell E19 on Sheet 1 = D, Cell E23 on Sheet 1 =Drop Down List from D1-D10 on Sheet 2.