See attached spreadsheet - it explains further what I'm looking for.
Basically, I have a table that automatically fills in data (that is found in another sheet) based on what a user picks. One column in the data is a hyperlink to a website. Once the VLOOKUP function finds the hyperlink, how do I get that hyperlink to be functional?Tractor Horsepower.xlsm
Use this formula:
=IFERROR(HYPERLINK(VLOOKUP($D$4,Data!$A:E,5,0)),"")
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
That works perfectly!!! Thank-you so much!!!!!
replying here with my actual issue.
Your formula works but only if the URL is the actual URL. If you edited the hyperlink to "text to display" to make it simplified, then the formula wont work anymore.
So are you making an observation - or asking your own question?Originally Posted by johndoePH
Your formula works but only if the URL is the actual URL. If you edited the hyperlink to "text to display" to make it simplified, then the formula wont work anymore.
if you are making an observation, thanks for that
If asking a question, please start your own thread (and reference this 1 if necessary)
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
Hi FDibbins - I actually do have my own thread with the same issue. I used tlafferty's formula but only work if the URL is the actual URL. If you edited the hyperlink to "text to display" to make it simplified, then the formula wont work anymore.
Any help is much appreciated. My own thread below. I'm pretty new so when I tried to paste the link in this comment it wont let me and I dont know how to link if there is a way.
It wont let you post a link until you have 10 posts. But if you get creative, you should be able to work something out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks