Drop Down based on a condition
 

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.

Drop Down based on a condition
 

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

--
Biff
Microsoft Excel MVP


"Sri Harsha" wrote in message
...
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.