I'm using Excel for accounting functions and have the I have the following
two formulas: "=MONTH(C6)+3" & "=VLOOKUP(A10,'Schol 2007
(Expanded)'!$A:$AE,$C$5)"

What the formulas do is pull financial information from one tab and insert
them into the respective column on another tab all based on the date of input
I specify.

The first formula looks at the date I specify and tells the Vlookup what
column I want returned. It works fine if I have the month's columns in the
data tab next to eachother, but what formula could i use if there is 1 gap
between months on the data tab?

for instance, January will still start on column 3 (or "C") as specified in
the first formula, but February doesn't start until column 5 (or "E") instead
of column 4 (of "D")

Thanks,