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 Name
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")))

Which:
1. Makes sure that there is a Vendor and Job Number Entered, if not it
gives one of two error messages "Need Job Number" or "Need Vendor".
2. Looks up the Job Name on the same row as the Job number in Sheet1 and
prints it in the selected cell in Column E

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 Column C of 2008
Jobs.

What I am getting:

All the results are hyperlinked regardless of the results of VLOOKUP Column
C's contents.

What I tried:

I tried creating an additional IF statement that would verify that Column C
had content using a vlookup0 and then hyperlink if vlookup=true or just
print the vlookup 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")))