Thread: Using IF statements with a drop-down list
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Using IF statements with a drop-down list
I think what you are looking for is Dependent lists

http://www.contextures.com/xlDataVal02.html
--
HTH,
Barb Reinhardt



"Steve Jamison" wrote:

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.
Reply With QuoteReply With Quote