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

Tom9o - Feb 23, 2013 at 06:38 AM - Latest reply:  tom9o
- Feb 24, 2013 at 04:08 PM

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
See more 

2 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Feb 23, 2013 at 10:36 PM
Thank you
I think you need to use combination of iF and VLOOKUP,

other way might be use a custom formula

Thank you, rizvisa1 3

Something to say? Add comment

CCM has helped 1813 users this month

Thank you
Hi rizvisa,

Worked a treat, Thanks.