Dragging formulas question

[papasmurfuo9]

Hi i need this formula

=IF(G16="","",'Allocation Detail'!K14)


that when i drag it to the right, the first reference goes up by column, and the second reference goes up by row , is this possible in any way, so one drag would change it to

=IF(H16="","",'Allocation Detail'!K15) then
=IF(I16="","",'Allocation Detail'!K16) etc etc

thanks in advance

[:) Sixthsense :)]

Try this...

=IF(G16="","",INDEX('Allocation Detail'!$K:$K,13+COLUMN(A:A)))

Drag it to right...

[zbor]

Try this:

Please Login or Register  to view this content.

[papasmurfuo9]

thanks guys, sorted.