Using Vlookup to return insted of 00/01/1900 [Solved/Closed]

Report
-
 tom9o -
Hello,

I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are dates this is ok when there is a date value in the cell that I am returning but when the returning cell is blank it is returning a default date of 00/01/1900 how can I get to show a blank instead of 00/01/1900

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
I think you need to use combination of iF and VLOOKUP,
like
=IF(vlookup(..)="","",Vlookup(..))

other way might be use a custom formula
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hi rizvisa,

Worked a treat, Thanks.

tom9o