Using Vlookup to return insted of 00/01/1900

Solved/Closed

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

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

Vlookup date 1/0/1900
Gta 1 download - Download - Action and adventure
Fnaf 1 download pc - Download - Horror
Little alchemy 1 cheats - Guide
X videostudio video editing app 20 1 instagram videostudio video editing - Download - Video editing
Igi 1 download - Download - Shooters

2 replies

Answer 1 / 2

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 23, 2013 at 10:36 PM

I think you need to use combination of iF and VLOOKUP,
like
=IF(vlookup(..)="","",Vlookup(..))

other way might be use a custom formula

Answer 2 / 2

tom9o
Feb 24, 2013 at 04:08 PM

Hi rizvisa,

Worked a treat, Thanks.

tom9o

Similar discussions

,">"&0),"") at the end of a countif formula

C program to print 1 11111 1111

license key

Similar discussions

Subscribe To Our Newsletter!