Formula not inserting blank instead it defaults 12:00:00 AM

[Rodney2485]

I have a Spreadsheet pulling data from a couple of cells and the issue i'm having is when the Ship time is blank my formula is putting in a default 12am time stamp instead of just showing a blank cell.

Formula i'm having trouble with is in the "Live Load" tab and column K

=IFNA(IF($B$2="","",XLOOKUP($B25,'Lavern File'!$B:$B,'Lavern File'!$K:$K)),"")

[#2 · Accepted solution]

@Rodney2485 

Since you lookup returns blank cells which are interpreted as zero time (0).

Fast workaround could be

=LET( ShipTime, XLOOKUP($B123,'Lavern File'!$B:$B,'Lavern File'!$K:$K, ""), IF($B$2="","", IF(ShipTime="", "",ShipTime) ) )

[#3]

@Rodney2485 

In K2:

=IF($B$2="","",LET(v, XLOOKUP($B2,'Lavern File'!$B:$B,'Lavern File'!$K:$K, ""), IF(v="", "", v)))

But shouldn't it be

=IF($B2="","",LET(v, XLOOKUP($B2,'Lavern File'!$B:$B,'Lavern File'!$K:$K, ""), IF(v="", "", v)))