formatting based on VLOOKUP results

[flamme20]

I have a table on one sheet and a doc on another which combines data from the first sheet and shows results based on VLOOKUP formulae.
In certain cases I need to have a one cell blank, in certain cases I need to have this cell with date results.

I applied date formatting on that cell - "DD.MM.YYYY"
When the date is not needed, I always manually apply this type of formatting - "0;-0;;@" so that the cell remains blank.

Can I somehow combine these two types of formatting into one, so that when the date is needed it'll be displayed, when not - the cell will remain blank?

Thank you in advance.

 

[T. Valko]

I have a table on one sheet and a doc on another which combines data from the first sheet and shows results based on VLOOKUP formulae.
In certain cases I need to have a one cell blank, in certain cases I need to have this cell with date results.

I applied date formatting on that cell - "DD.MM.YYYY"
When the date is not needed, I always manually apply this type of formatting - "0;-0;;@" so that the cell remains blank.

Can I somehow combine these two types of formatting into one, so that when the date is needed it'll be displayed, when not - the cell will remain blank?

Thank you in advance.

Maybe this...

dd.mm.yyyy;;;@

 

[flamme20]

Maybe this...

dd.mm.yyyy;;;@

Well, yes, that's fine! Thank you very much!

 

[T. Valko]

Well, yes, that's fine! Thank you very much!

You're welcome. Thanks for the feedback!