View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katja
 
Posts: n/a
Default Validy check in one coulmn to limit input options in another?

I would like to limit input options in one column depending on the entry in
another column (e.g. column 1 has input possibilities a, b, or c; if the
input is a, the options in column 2 should only be aa, aaa, or aaaa; if it is
b, only bb, bbb, or bbbb, etc. ...). How can I achieve this?