Try this instead of your first formula:

=MONTH(C6)*2+1

will give 3 for Jan, 5 for Feb, 7 for Mar etc.

Hope this helps.

Pete

On Oct 11, 9:04 pm, bmo wrote:
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,