VLookup

[rutica]

I am using Excel 2003.

Is there a better way to do what I'm trying to do? Please see my attached spreadsheet where users need to enter quarterly data for the fiscal year.

1st Quarter is Oct, Nov, Dec; 2nd Quarter is Jan, Feb, Mar; 3rd Quarter is Apr, May, Jun; 4th Quarter is Jul, Aug, Sep

So in the months of Jan, Feb, Mar: the user should enter data in column C, and the formulas in columns H and I should use the data entered in column C.
In the months of Apr, May, Jun: the user should enter data in column D, and the formulas in columns H and I should use the data entered in column D.
In the months of Jul, Aug, Sep: the user should enter data in column E, and the formulas in columns H and I should use the data entered in column E.
In the months of Oct, Nov, Dec: the user should enter data in column F, and the formulas in columns H and I should use the data entered in column F.

For example, today is March 15, so the formulas in cells H and I should reference the data entered in column C.

I created a vlookup table in cells O2:P13 where I list the 12 months of the year, the related cells in row 6 and the Quarter names. I got everything working for row 6. I have formulas in cell H6 and I6 and it works fine.

Now, do I need to expand my vlookup table to include the other rows? Am I on the right track or is there a better way to do this?

Thanks,