Good morning,

I am having an issue with expanding formulas. I think an example might be clearer.

Normally when you pull down a sequence of numbers it just expends e.g. A1 = 1, A2 = 2 pulling it down would make A3 = 3 and so on.

In this case i am using a1 =HLOOKUP(‘Input ‘!$B$1;’InPut2’!$A:$FI;2;FALSE),

a2 =HLOOKUP(‘Input ‘!$B$1;’InPut2’!$A:$FI;3;FALSE),

When I try to pull this formula down, it just repeats the sequence instead of expanding it, how do I solve this? Manually changing this is not on option =).

Thanks in advance,

Pim

By: Pim