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,