I'm attempting to use the vlookup function to find the latest entry in a data range then hyperlink it to another sheet in the same workbook, but each time I click on the cell I receive an error message that says, "cannot open the specified file".
I've checked the file properties and the Hyperlink Base box is empty.
First Attempt:
=HYPERLINK(VLOOKUP(A3,'Issue'!$A$2:$A$5,1,TRUE),A3)
Second Attempt:
I can't combine the two, but individually the Vlookup function: =VLOOKUP(A3,Issue!$A$2:$A$5,1,TRUE) and the Hyperlink function: =HYPERLINK("#"&CELL("address", Issue!A3), Issue!A3) both work.
Please let me know if there's a syntax error in this formula. Thank you
=HYPERLINK(VLOOKUP(A4,"#"&CELL("address",IssueLog!$A$2:$A$5),1,TRUE),A4)
Third Attempt:
I solved the primary issue with this formula:
=HYPERLINK("#"&ADDRESS((MATCH(A3,IssuesLog!$B$2:$B$5,1)),2,,,"IssueLog"),A3)
Now Im having a referencing problem. I need it to be able to find the last instance of the strings/ numbers in a column and it seems to be referencing different cells majority of the time.
Bookmarks