Attempting to return a list of preceding years; for example, for the year 2014, I want to

I attempted to create a respective formula to respectively either do the following (MK I) or the subsequent (MK II):

MK I

1. To populate a group of cells with the four consecutive years preceding the, for our purposes, main year.

For example, one would enter the year 2014, then in a group of cells one would see the following cells each in only one cell and each with a respective cell:

2013

2012

2011

2010

This will quite plainly entail listing out the number of years in a series.

2. One compares a number in another cell to ascertain whether that number equals one of the years noted above, 2010 inclusive to 2014 inclusive.

MK II

1. One enters a main year for evaluation, such as for example, 2014, and then in another cell enters another year, such as 2011, and one receives an answer as to whether 2011 equals a year from the period inclusive of 2010 to inclusive of 2014.

Thank you, that seems quite appropriate. I will evaluate this formula further at some point perhaps.