Previous Topic Next Topic

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
Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Lastest Whastapp for Nokia X2-01
YvanRwanda -
Ambucias -

5 responses
how to watch a video from youtube by using nokia C3
Aklile -
hackimist -

1 response
C3-00
Rabul -
BunoCS -

1 response