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)),””)

​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)),””)  Read More

​