Date reporting in cell
 

Hi,
When using the following formula:
=VLOOKUP($C$2,'Mandatory Training'!$A$5:$Z$100,A6,0)
The cell reports a date even though their is no date entered into the cell
it is looking at on the other spreadsheet. How can I get it to only rpoert
the date if one is entered on the training sheet and not if one is not
entered.

Also when using the following formula:
=IF(F5<0,IF(VLOOKUP(D5,'Mandatory
Training'!$A$102:$B$105,2,0)F5,"Overdue",0),0)
The cell reports a 0 when I want it to rpoert nothing or "overdue"
Where am I going wrong?
Can you make a cell flash?
Thanks in anticipation
Jason

Date reporting in cell
 

=if($c$2="","",
if(isna(vlookup(...)),"no match",if(vlookup(...)="","Overdue",vlookup(....)) ))

xl2007 added an =iferror() that makes the formula a little easier.

Boenerge wrote:

Hi,
When using the following formula:
=VLOOKUP($C$2,'Mandatory Training'!$A$5:$Z$100,A6,0)
The cell reports a date even though their is no date entered into the cell
it is looking at on the other spreadsheet. How can I get it to only rpoert
the date if one is entered on the training sheet and not if one is not
entered.

Also when using the following formula:
=IF(F5<0,IF(VLOOKUP(D5,'Mandatory
Training'!$A$102:$B$105,2,0)F5,"Overdue",0),0)
The cell reports a 0 when I want it to rpoert nothing or "overdue"
Where am I going wrong?
Can you make a cell flash?
Thanks in anticipation
Jason

--

Dave Peterson