In Excel, can a function yield a drop-down list?
 

I need an IF function to yield a drop-down list. Basically, if a given value
is matches certain parameters, it allows a choice in a second field. But I
can't get the IF function to accept a drop-down list as a result, and know of
know other way to allow user selection of a single item from a list.

In Excel, can a function yield a drop-down list?
 

Hi!

Take a look he

http://contextures.com/xlDataVal02.html

Biff

"BMB" wrote in message
...
I need an IF function to yield a drop-down list. Basically, if a given
value
is matches certain parameters, it allows a choice in a second field. But
I
can't get the IF function to accept a drop-down list as a result, and know
of
know other way to allow user selection of a single item from a list.

In Excel, can a function yield a drop-down list?
 

Thank you.


"Biff" wrote:

Hi!

Take a look he

http://contextures.com/xlDataVal02.html

Biff

"BMB" wrote in message
...
I need an IF function to yield a drop-down list. Basically, if a given
value
is matches certain parameters, it allows a choice in a second field. But
I
can't get the IF function to accept a drop-down list as a result, and know
of
know other way to allow user selection of a single item from a list.