Hi,
I have used an iferror formula on a date field and where the date field is blank in the worksheet I am looking up it has returned 01/01/1900 instead of leaving it blank.
My formula:=IFERROR(VLOOKUP([@[Batch No.]],'[0. OFM and Solutions MFG Plan.xlsx]Solution MFG Plan'!$A:$D,4,FALSE),0)
The column that I am putting this formula into is formatted as date format.
Can someone offer suggestions of how to get this to work.
Thank you
Bookmarks