Hi all,
I am using formulas HYPERLINK and VLOOKUP as shown in the attached file. However, when the result is actually a link to a place within the document, the link no longer works. Any suggestion as how to fix this are more than welcome
Thank you very much for taking the time with this!
The same question has been asked here: https://www.excelforum.com/excel-gen...k-vlookup.html
You might want to keep your eye on that thread.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please try
=HYPERLINK("#"&VLOOKUP(B8,A2:B5,2,FALSE))
You need to make the formula part of the HL function, something likethis...
=HYPERLINK("#"&"'"&VLOOKUP(B8,A2:B5,2,FALSE)&"'!A1",VLOOKUP(B8,A2:B5,2,FALSE))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for your answers!
The first formula works great when everything is on the same spreadsheet. The link stops working if the formula is moved to another sheet though. Any suggestions as to how to fix that?
Thank you again for your time.
If the formula is on a different sheet, adjust the vlookup accordingly
Otherwise show/explain what you mean?
I was wrong to believe that the error was caused because of the formula being in a separate spreadsheet. I noticed that the formula works fine in the sample file that I uploaded in this thread until the moment that I format the cells that contain the values as a table. Then the link appears, but when clicked it produces two messages.
The first being "Microsoft Office has identified a potential security concern. Hyperlinks can be harmful.... Do you want to continue?" to which I click "YES" and then I get the second one which says "Cannot open the specified file".
The link is to a different spreadsheet in the same workbook.
Any suggestions?
If the attached WB contains your table, fine, otherwise update the file please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks