Using IF statements with a drop-down list

[Steve Jamison]

Is it at all possible to use an if statement that when TRUE will display a
drop-down list in the given cell? For example: IF cell A1=100 I want to
display a drop-down list otherwise(if false) nothing.

 

[Barb Reinhardt]

I think what you are looking for is Dependent lists

http://www.contextures.com/xlDataVal02.html

 

[Steve Jamison]

Right on point. Thank you very much.

I think what you are looking for is Dependent lists

http://www.contextures.com/xlDataVal02.html