I have an Excel 2000 spreadsheet with 2 sheets in it that is my Purchase
Order Log.

Sheet1 = "2008 Jobs", Column A = Job numbers, Column B = Job Names
Column C = Network path to that Job's folder (when there is one). ie:
'\\server\salesman\projects\jobfolder'

Sheet 2 = "PO's 2008", Column C = Vendor Name, Column D = Job Number (Manual
entry), Column E = Currently contains the following function:

IF(AND(C10,D10)=TRUE,VLOOKUP(D1,'2008 Jobs'!A:C,2,0),IF(AND(C1<1,D1<1),"",
IF(D1<1,"Need Job Number","Need Vendor")))

What I want to do:

I want to hyperlink the Job Name (supplied by VLOOKUP) to the Network Path
(also supplied by VLOOKUP) only when there is information in the Network
Path Column of 2008 Jobs.

What I am getting:

When I mouse over the Job Name the cursor changes to the pointing hand
cursor whether or not the text has been hyperlinked which seems to imply that
all the results are hyperlinked regardless of the results of VLOOKUP Column
C's contents.

What I tried:

I tried creating an IF statement that would verify that Column C
had content using VLOOKUP(D5,'2008 Jobs'!A:C,3,0)0 and then HYPERLINK the
name to the Network path when IF()=TRUE or print the Job Name without the
hyperlink when IF()=FALSE.

My hyperlink formula:

IF(AND(C50,D50)=TRUE,IF(VLOOKUP(D5,'2008
Jobs'!A:C,3,0)0,HYPERLINK(VLOOKUP(D5,'2008 Jobs'!A:C,3,0),VLOOKUP(D5,'2008
Jobs'!A:C,2,0)),VLOOKUP(D5,'2008
Jobs'!A:C,2,0)),IF(AND(C5<1,D5<1),"",IF(D5<1,"Need Job Number","Need
Vendor")))

How can I get this to work properly?
Also is there a way to get the cells that are hyperlinked to a location to
change the text formating to a hyperlink syle like when I right-click link?

PS I am not allowed by my managers to use macro's

More details available if needed.. please Help!