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