Vlookup based on date specified

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
close...but still not it. I have 3 columns before the first month starts,
then 1 spacer between each month; so Jan is column D, Feb is Column F, March
is column H and so on.

I could change the amount of columns before the first month starts if need
be...either adding or deleting a row...

I appreciate the help!!!!!
 
GOT IT!!!! Thanks....=MONTH(C6)*2+2!!!!!!


Pete_UK said:
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
Click to expand...
 
You did say that January would start at column C, but I see that you
have figured it out.

Pete
 
Back
Top