Excel 2007

Hello,
I have a table that lists historical rates of returns for years between 1901 to 2010. I'd like to create a table that 1) will list each year between an input date range and 2) that shows the annual return for each year in that date range. For example, if the begin year and end year are input (e.g. 1920 begin year and 1950 end year), I want each year listed in that date range in one column and then the corresponding percent return in another column.

What formulas do I need to use to create this new table? I think I would use the VLOOKUP to produce the percent return but not sure what formula to use to list the years between a range.

Thank you for your help.