Hi there,
I have a formula below that is working great so far. However, I wanted to add a date reference to it.
For example if D1="03/29/19"....then apply the current formula below, if not just ""
=IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES")
It is not doing what I wanted to accomplish though, just giving me blank, or error message to revise my formula.
Thank you in advance for your help.
eyjie
I have a formula below that is working great so far. However, I wanted to add a date reference to it.
For example if D1="03/29/19"....then apply the current formula below, if not just ""
=IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES")
It is not doing what I wanted to accomplish though, just giving me blank, or error message to revise my formula.
Thank you in advance for your help.
eyjie