Make a list which change in years based on database

There are columns with names that are repeted inconsequntly of times and each time it comes up a number and established year.

Attached file present what I need.

I want a list which can continue from years on and depending on a year of the pc it can upgrade each year.
Bad explanation, though have a look in xls file where I think it gives justice what i need help with.
Thanks

See attached. I changed your years to formulas so they will always update. The basic formula, this one in R3, is based on index / match:

Please Login or Register  to view this content.

I changed the first and last formulas to look for anything equal to or below the first year, and equal to or above the last year. Is this what you're looking for?

thank you great done