identify cell values in excel 2010

Paul,

I thought I could use the same function everywhere hence I didnot post my complete question. Apologize for that. But please find the spreadsheet attached.The data is in Sheet1. The output has to be listed in the cells as listed in the spreadsheet. Also Please note that per my requirement I have to collect and use data from year 1975 to the current year and the number of records will also be increased. I have also put an example in the spreadsheet.

Thank you so much for your help with this.