I have the following list in AC3:AD11

Qtr Ago Date
8 6/30/2004
7 9/30/2004
6 12/31/2004
5 3/31/2005
4 6/30/2005
3 9/30/2005
2 12/31/2005
1 3/31/2006

In Column AA, rows 1000+, I have numbers randomly dispersed 1 through 8.

In Column AC, I would like to return the proper date correpsonding to each
number. How do I do this? I can't/don't want to use nested if statements.
I supsect the best way is via a defined name?

Thanks for your help!