Thread: How to dynamically change the list in drop down list based on thevalue of another cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benmcclave@gmail.com is offline
external usenet poster
  
Posts: 29
Default How to dynamically change the list in drop down list based on thevalue of another cell?
Hi,

You can do this with named ranges. For example, you could name the full list (A1:A3) "Full" and name the shorter list (cell A1) "Short". Then put this formula in the data validation formula bar: =if($B$1=0, Short, Full).

Ben
Reply With QuoteReply With Quote