Data validation list limited by choise in other list

[svjensen]

I need to input a start year and an end year using data validation lists.
The time span is 2010 - 2020.

The first list is easy, but I would like the second list (end year) to be defined by the start year. If for example 2015 has been chosen as the start year, it should not be possible to select an end year earlier than the start year (the list should then be '2016', '2017', '2018', '2019', '2020').

/Soren

 

[Andrew Poulsom]

If your list is in A1:A10 and your start year is in B1, you can use:

=INDEX($A$1:$A$11,MATCH($B$1,$A$1:$A$11)+1):$A$11

as the Source for end year.

 

[svjensen]

Splendid! Thank you.