Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

Date reporting in cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Boenerge - 12 Sep 2007 13:42 GMT
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 - 12 Sep 2007 13:48 GMT
=if($c$2="","",
if(isna(vlookup(...)),"no match",if(vlookup(...)="","Overdue",vlookup(....))))

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

> Hi,
> When using the following formula:
[quoted text clipped - 12 lines]
> Thanks in anticipation
> Jason

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.