VLOOKUP Returning date as 00/01/1900

[Liam_1988]

My formula is returning date as 00/01/1900 with this formula:
=IFERROR(VLOOKUP($A3,'Processing Analytics.xlsx'!Table1[[Completion time]:[Closure Date:]],MATCH("Closure Date:",'Processing Analytics.xlsx'!Table1[[#Headers],[Completion time]:[Closure Date:]],0),0),"")

I've tried looking through the other articles and tried adding in an additional VLOOKUP statement but it's not working.

I need the return value to be blank if the cell is empty.

Any ideas?

 

[Fluff]

How about

=IFERROR(1/(1/VLOOKUP($A3,'Processing Analytics.xlsx'!Table1[[Completion time]:[Closure Date:]],MATCH("Closure Date:",'Processing Analytics.xlsx'!Table1[[#Headers],[Completion time]:[Closure Date:]],0),0)),"")

 

[Liam_1988]

How about

=IFERROR(1/(1/VLOOKUP($A3,'Processing Analytics.xlsx'!Table1[[Completion time]:[Closure Date:]],MATCH("Closure Date:",'Processing Analytics.xlsx'!Table1[[#Headers],[Completion time]:[Closure Date:]],0),0)),"")

Thank you Fluff,

Unfortunately that didn't work. The "IFERROR" was referencing the "(1/(1/(" part of the formula and selecting data from the same workbook instead of the correct workbook.

 

[Fluff]

That formula does exactly what your formula did, but if the result of the formula is 0 or blank you will get a blank cell.