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.