Forum Discussion
AutoFill
Hi, How do I autofill a formula that should take the data from e.g. colum A:B, C:D, E:F, etc? I tried to fix the column ($A:$B, $C:$D, $E:$F) but the pattern was not recognized, instead it gave me ...
In B22:
=IFERROR(VLOOKUP($A22;OFFSET(Data!$A:$B;0;2*COLUMN()-4);2;FALSE);"")
Fill to the right (and down)
Great, many thanks! Even a smarter solution