Solved Using Vlookup to return a blank insted of 00/01/1900

February 23, 2013 at 03:37:09
Specs: Windows 7
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: Using Vlookup to return a blank insted of 00/01/1900

Report •


#1
February 23, 2013 at 06:19:22
✔ Best Answer
First, a posting tip:

Try tossing in some punctuation and capitalization every now and then. When you post one long "sentence" with no periods it makes your post very hard to read.

If you are sure that the cell is blank, then you can force a blank to be returned with this formula:

=IF(VLOOKUP(A2,$D$6:$E$7,2,0)="","",VLOOKUP(A2,$D$6:$E$7,2,0))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 23, 2013 at 07:12:09
Thnaks again DerbyDad03 its works a treat,

tomR


Report •

Related Solutions


Ask Question