View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robc
 
Posts: n/a
Default adding a drop down list to an If Statement?

How or can I add a drop down list to an if statement. I have added all 50
states to cell A1 as a drop down choice. I want the statement to be if cell
A1 equals Alabama then cell A2 will have a drop down box for the counties in
that state. Is there a way to do this?