incorporate date in IF/VLookup

[eyjie]

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

 

[Joe4]

Welcome to the Board!

Try:

[COLOR=#333333]=IF(D1=DATE(2019,3,29),IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES"),"")
[/COLOR]

or

[COLOR=#333333]=IF(D1=DATEVALUE("3/29/2019"),IF(ISNA(VLOOKUP($B4,MARCH,10,FALSE))=FALSE,"NO","YES"),"")
[/COLOR]

 

[eyjie]

Dear Joe4,

Thank you so much. What seemed to be so hard for me, looked like so easy for you...it worked!!!! I appreciate your quick and definitely helpful response.

Regards,
eyjie

 

[Joe4]

You are welcome.

The key is in how you present the date. The following will not work:
=IF(D1="3/29/2019",...
because anything enclosed in double-quotes is treated as Text, not as a Date.
So you need to do something to tell it is is date (by using the Date or DateValue functions).

 

[eyjie]

Thank you, these are great recommendations in how to use excel functions.
I have a follow up question please, since the data is growing on a daily basis, I would like to include the date as part of the vlookup reference table as another look up column, or I can create a separate date table vlooup reference if needed; if so, how can that function replace the date requirements in the formula. Thank you again. I appreciate your help.

Regards,
eyjie

 

[Joe4]

I am not sure I understand what you are asking now.
Can you walk us through an actual example?