Incrementing by 1 in every other column

[Guest]

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

 

[Guest]

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

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

HTH,
Elkar

 

[Guest]

Elkar,
Your formula segment did the trick. Thanks a million!
Bob