Incrementing by 1 in every other column

B

Bob

Cells L3 and M3 are merged cells. The formula in cell L3 is:

=IF(Period_End>=COLUMN(L1)-11,VLOOKUP(COLUMN(L1)-11,Period_End_Lookup,2),"")
= May 2007

Cells N3 and O3 are also merged cells. The formula in cell N3 is:

=IF(Period_End>=COLUMN(N1)-12,VLOOKUP(COLUMN(N1)-12,Period_End_Lookup,2),"")
= Jun 2007

Notice that I had to hard-code 11 in the 1st formula, and 12 in the second
formula in order for the dates to come out correctly.

Rather than hard-code any numbers, I would prefer to use an algorithm within
the existing formulas that would increment the count by 1 even though the
formulas are located in every other column.

Any help/guidance would be greatly appreciated.

Thanks,
Bob
 
E

Elkar

Try substituting this for the number 11. When copied, it should increment as
you want.

(INT(COLUMN(L1)/2)+5)

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top