Drop Down based on a condition

[Sri Harsha]

Hi,
I want a cell to display a drop down based on the input the user gives in
the reference. For example, If in A1, i enter "Release Note", It has to
display a set of options and if i enter "User Guide" in A1, a different set
of options. Is it possible?

Regards,
Sri Harsha.

 

[T. Valko]

Create a list of the options that are associated with Release Note.

Let's assume this list is in the range X1:X10.
Give this range the defined name of Release Note
Then, as the source of the drop down list in A1 use:

=INDIRECT(A1)

Do the same thing for User Guide