Solved Return blank instead of 00/01/1900

March 20, 2017 at 17:09:56
Specs: Windows 64
Hello I am trying to return a blank instead of 00/01/1900 when there is no data in the cell yet.

Thanks

=IFERROR(VLOOKUP([@Park],$A$1:$H$198,5,FALSE),"")


See More: Return blank instead of 00/01/1900

Reply ↓  Report •


#1
March 23, 2017 at 20:18:43
✔ Best Answer
I don't think the IFERROR() will work, try this:

=IF(VLOOKUP([@Park],$A$1:$H$198,5,FALSE)=0,"",VLOOKUP([@Park],$A$1:$H$198,5,FALSE))

Check the return value of the VLOOKUP() first.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
April 4, 2017 at 08:59:25
Worked great! Thank you.

Reply ↓  Report •
Related Solutions


Ask Question