I am using Excel 2010 and I am linking data between worksheets in a workbook:

='Sheet1'!J3

I am in Sheet 2 copying data from cell J3 in Sheet 1

Some of the cells on Sheet 1 in this (and other columns) have blank cells, if for example the column has dates, if there is no date then the formula (='Sheet1'!J3) returns 1/0/1900, if there is text in the field then the formula returns a 0.

what can I add to ='Sheet1'!J3 to ignore blank cells

I tried this and it does not work:

=('RAW DATA'!J2,IF('RAW DATA'!J2="", ""))