Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel mailto formula

Status
Not open for further replies.

dippncope

Technical User
Sep 22, 2008
88
US
Needs some excel help please. I have a formula that will search column G looking for a city. when it finds city I need it to put a mailto hyperlink in column f.
Here is what I have
=IF(ISNUMBER(SEARCH("Albany",G:G )),"mailto:email1@123.com ","")&IF(ISNUMBER(SEARCH("CINCINNATI",G:G )),"mailto:email2@123.com","")

What I end up with is mailto:email1@123.com in the correct spot for the correct city but what I would like is for it to be a hyperlink and not just the text. If possible I would like to put formula into a macro. Any help is greatly appreciated. Thanks
 


Hi,

Did you try the HYPERLINK function?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Yes I did but could not get it to work in formula.
kjv1611 link put me in the right direction. I just need to add another column, probably because I am a noob and just hacking my way around. I am heading to book store this weekend so I can do some reading.
Thanks to both of you for helping
 


[tt]
=HYPERLINK(IF(ISNUMBER(SEARCH("Albany",G:G )),"mailto:email1@123.com ",""))&HYPERLINK(IF(ISNUMBER(SEARCH("CINCINNATI",G:G )),"mailto:email2@123.com",""))

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Thanks Skip and kjv1611. I have never been disappointed with this site or its people.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top