Hello,

I have a formula in N4 which have been dragged down to N108 in sheet 2.

In sheet 1, I want to be able to drag this formula N4-N108 but horizontell instead in the cells b2-AC2

I have tried using the Indirect function like this: INDIRECT("B" & COLUMN('Sheet 2'!N1))

But it doesnt seem to be working, solutions please?