Thread: VLOOKUP
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default VLOOKUP

well, think it should have worked. "00/01/1900" is simply a zero returned by
the vlookup for blank cells where the formula cell is formatted as dd/m/yyyy.

Here's a quick sample to illustrate that it works:
http://cjoint.com/?ivpswpsoqg
bollard.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bollard" wrote:
Hi Max

I tried this, but it didn't work. I also tried replacing the 0- with "" or "
", but that didn't work either.

Seemed such a neat idea too.