Hi,

I have a problem with the following IF/OFFSET formula which is dragged down the length of a worksheet:

=IF(ISERROR(IF(A,DataLink!D1550)),"",IF(A,DataLink!D1550))
Where A =OFFSET(DataLink!$A$1,0,0,COUNTA(DataLink!$A:$A),1)

The DataLink worksheet is fed from a database and exists in the same spreadsheet as the worksheet which contains the above formula. When the spreadsheet is opened, DataLink is refreshed, invariably with new rows of data.

The problem I am facing is that when DataLink is refreshed, the IF formula in the first new row of data changes its row reference to the last new row of data and each subsequent row reference follows in numerical order – the result being that blank fields are referenced and no data is being pulled through.

Any ideas? Your help would be gratefully appreciated.

Thank you