VLOOKUP but only Return the result which is not equal to the word NULL

[bhenlee]

HI Experts,

I need to do a vlookup but the result should only show the first result which is a VALID DATE

Essentially the result of the VLOOKUP should always be date.

Please help