Ignoring blank cells when linking data between excel worksheets

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="", ""))

That does not work

---------- Post added at 05:00 PM ---------- Previous post was at 04:59 PM ----------

Excel is looking for a True, False in the formula when I try it