Return blank cell for IFS formula for Vlookup data with blank cells.

Hi all,

I have an IFS formula designed to return date values from vlookups based on 4 different scenarios. Where the returned data is blank i.e. no date has been entered into the lookedup cells, I want the returned cell value to be blank rather than return '0' (it's actually returning 00 January 1900 but that's expected in this use case).

Does anyone know how I can ensure that the cell remains blank if the lookup cell has no data? So, I specifically want a solution for 'if blank' not 'if not found'. I tried including Len=0,"" within the formula but this was too many arguments.

Here's the formula which is returning a 'zero' value for blank cells at present:

=IFS($B$19=Sheet1!$A$1,VLOOKUP('Invoice Template'!$B$10,Customers!$B$1:$AN$245,19,FALSE),$B$19=Sheet1!$A$2,VLOOKUP('Invoice Template'!$B$10,Customers!$B$1:$AN$245,25,FALSE),$B$19=Sheet1!$A$3,VLOOKUP(Customers!$B$1:$AN$245,31,FALSE),'Invoice Template'!$B$19=Sheet1!$A$4,VLOOKUP('Invoice Template'!$B$10,Customers!$B$1:$AN$245,37,FALSE))

Thanks in advance for any suggestions