Hyperlinking with Formula

[Schubee2]

Good Afternoon,

currently I am using isna and vlookup to generate a report worksheet from a list on different worksheet in the same workbook. essentially, i'm using the "reporting checklist" sheet to input the information, and the "status report" worksheet to neatly present the information when printed since the input sheet is 30 cells wide. I'd like to hyperlink to the location where the information is generated from for simple editing as necessary, as the input sheet is also 1,000 rows deep and growing.

i have this formula:

=HYPERLINK(IF(ISNA(VLOOKUP(L7, 'Reporting Checklist'!AG:AR,1,FALSE)),"-----",VLOOKUP(L7,'Reporting Checklist'!AG:AR,4,FALSE)),IF(ISNA(VLOOKUP(L7, 'Reporting Checklist'!AG:AR,1,FALSE)),"-----",VLOOKUP(L7,'Reporting Checklist'!AG:AR,4,FALSE)))

the formula i'm using without the hyperlink is:

=IF(ISNA(VLOOKUP(L7, 'Reporting Checklist'!AG:AR,1,FALSE)),"-----",VLOOKUP(L7,'Reporting Checklist'!AG:AR,4,FALSE))

my result is that of an appropriately displayed reference with a hyperlink status, but when clicked, states "Cannot open the specified file."

can anyone suggest how i can fix the hyperlink?

any help is much appreciated.
thanks,

b