"Murray" wrote:

You could try using the OFFSET function:

=IF(ISBLANK(OFFSET(Sheet1!A1,15,0)),"-",OFFSET(Sheet1!A1,15,0))

The OFFSET function takes a reference position and then specifies a
number of rows and columns to offset from ie in this case, from cell
A1 offset 15 rows down and zero rows across. Doing it this way allows
you to delete rows and it should still be OK.

HTH

Murray





You are a genius and I love you to no end you have no idea. All my excel
questions go here from now on.