I have this formula in cell C5 which I am trying to copy down to C150
But in diong so it only places the same value as Cell C5 in all the
cells.
I have to individually do a CTRL SHIFT & ENTER for each cell to update
the value.

=IF(ROWS($B$5:B5)$IQ$2,"",INDEX('T&C'!$K$3:$BT$3, MOD(SMALL(IF('T&C'!$K
$5:$BT$138<$IQ$1,(ROW('T&C'!$K$5:$BT$138)-ROW('T&C'!$K$5)+1)*10^5+COLUMN
('T&C'!$K$5:$BT$138)-COLUMN('T&C'!$K$5)+1),ROWS($B$5:B5)),10^5)))