VLOOKUP Returning date

[jforeyt]

I have a spreadsheet listing employee's and the dates of their reviews. When I do a vlookup to return the date of the review, if there is no date in there it returns a date of 1/0/1900, how can I make it return nothing like it is in my worksheet that I'm looking it up from?

Thanks!!!!

 

[BeingYogi]

May Be:


=if(isblank(ur vlookup formula),"",ur vlookup formula)

 

[jforeyt]

I can't get that to work either.

 

[BeingYogi]

post ur formula

 

[jforeyt]

=IF(isblank(=VLOOKUP(C6,apple,3,FALSE),"",=VLOOKUP(C6,apple,3,FALSE)))

 

[BeingYogi]

Try This:


=IF(isblank(VLOOKUP(C6,apple,3,FALSE)),"",VLOOKUP(C6,apple,3,FALSE))

 

[jforeyt]

Worked perfect! Thanks so much you have made my HR departments day!!!

 

[ZachD]

=if((ur vlookup formula)=0,"",ur vlookup formula)

looks like you beat me to it.