Hi All.. I have a formula which is unfortunately pulling in cells where no data exists and returning 0 and when a date is zero I am getting the 00/01/1900. How can I modify it to NOT enter blank dates or zero's pls.

Any help would be awesome..

Formula is

IF($G3246="GB03",VLOOKUP($N3246,'GB03'!$A$2:$G$99999,4,FALSE),

IF($G3246="GB30",VLOOKUP($N3246,'GB30'!$A$2:$K$99999,3,FALSE),""))))))

Your formula is not valid. Why do you have so many parenthesis at the end?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

2 options come to mind: 1 - Hardcode a zero test into your formula:

=IF($G3246="GB03",IF(VLOOKUP($N3246,'GB03'!$A$2:$G$99999,4,0)=0,"",

VLOOKUP($N3246,'GB03'!$A$2:$G$99999,4,0)),IF($G3246="GB30",

IF(VLOOKUP($N3246,'GB30'!$A$2:$K$99999,3,0)=0,"",

VLOOKUP($N3246,'GB30'!$A$2:$K$99999,3,0)),""))2 - Set your spreadsheet options to not display 0 values. This will hide

zero values, so this option may have undesirable impacts on your workbook.all

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History