Hello all. I have an easy one I think but it has me stumped. I have an email address and a web address that work fine if pick on them. If I do a formula of any kind to pick the address for me the resulting address does not work. I attached a file to show what I mean. I don't know why the result of the formula does not work. Jon
Try this:
=HYPERLINK(E1)
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks Ali that does work. I am sorry I didn't give a very good example file. I have reattached a file with a better example. I am using vlookup to find email and web addresses from a table.
Still looking for help on this topic. Thanks in advance.
Are you still using Excel 2007???
I would have hoped that you would have at least tried this, as it's not a massive leap from what I gave you before, but there we go!
=HYPERLINK(VLOOKUP(A2,Contacts,2,FALSE))
=HYPERLINK(VLOOKUP(A2,Contacts,3,FALSE))
Ali thanks again for the reply. We are using Excel 2019 now. I am sorry for not updating that information. As far as trying similar
formulas, I did but they weren't working. I plugged in your formulas above into my sample workbook and they do not work either.
I have attached the file in hopes of finding out why they don't want to work. Jon
HYPERLINK should work in Excel 2019. When I open your workbook, everything IS working, so I don't think I can help you - sorry.
Fromn the MS support page:
HYPERLINK function
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010
Last edited by AliGW; 07-18-2022 at 10:53 AM.
Thanks Ali. If I type in an email address it works fine, takes me to my default email. Same for a web address, takes me to my default web browser. It just doesn't work if there is a formula involved.
Try this:
=HYPERLINK("mailto:"&F3,F3)
and this:
HYPERLINK("mailto:"&VLOOKUP(A2,Contacts,2,FALSE),VLOOKUP(A2,Contacts,2,FALSE))
Then try this:
=HYPERLINK("https://"&G3,G3)
and this:
=HYPERLINK("https://"&VLOOKUP(A2,Contacts,3,FALSE),VLOOKUP(A2,Contacts,3,FALSE))
Both of those worked for the email address. Didn't try them for the web address since the formula contains "mailto:"
See my second post for the URL.
Glad to have helped.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Sorry, the web address does work as well. Some how copied the mailto: formula twice. Thank you for all the work.
The web address formula has nothing to do with the mailto formula, and yes, it does work (if you do it correctly - see attached).
If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks