issue with Blank cell

[garethjohn]

Hello all
This is my first post here and I am hoping someone could help here, as everyone in my office is stumped!

I have a spreadsheet looking at dates, specifically finish dates for a project.
Within the first worksheet I have a cell where I can enter in a date ie: 01/10/2010.
If the cell is blank, it is highlighted red via conditioanl formatting.

The cell is in question is blank, no value. (lets call is A1)

The 2nd worksheet relates to this by the following formula:

=IF(ISBLANK(VLOOKUP($C$3:$C$212&"Latest",'Milestone Dates'!$N$5:$U$94,8,FALSE)),"",VLOOKUP($C$3:$C$212&"Latest",'Milestone Dates'!$N$5:$U$94,8,FALSE))


This will find the cell above (A1) and thus show blank.

Also note there is another cell (Cell C1) which does have a value (date) in it.

Now comes the problem!

the final worksheet, I have a cell with the following formula:

=IF(ISBLANK(VLOOKUP($B6&"Post Implementation",'Phase Dates'!$A$3:$Q$212,14,FALSE)),VLOOKUP($B6&"Post Implementation",'Phase Dates'!$A$3:$Q$212,11,FALSE),VLOOKUP($B6&"Post Implementation",'Phase Dates'!$A$3:$Q$212,14,FALSE))


The cell shows blank.

What I am trying to do here, is ask excel show a date.
ideally I always want cell A1, but if A1 is blank I want C1 to show.
The above formula shows a blank, whereas it should show C1 date.

The formula I think is fine, if I go to the 1st worksheet and enter in xx, the last worksheet shows xx. But if I delete this xx, nothing is shown. C1 should show tho


Any thoughts?


Thanks in advance!

PS: I am using Excel 2003