OK let me just add an excerpt from the actual file to make it more clear. The formula you mentioned would still require some kind of manual input of the years because in the example it only had 1990, 1991 and 1992 in it. But in reality some cars are only made in the 80's while other ones are from the new millenium etc. So with this formula I would need to look up per car the lowest and highest year it was made in and enter that into a formula. That would still be a huge task.

Attached a piece of the original file I am working with:
car_applications_actuallist.xlsx