excel mailto formula

[dippncope]

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

 

[kjv1611]

You should be able to work in something like the formulas discussed here:

http://www.excelforum.com/excel-general/695065-mailto-link-in-excel-with-subject-and-body.html

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Hi,

Did you try the HYPERLINK function?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dippncope]

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

 

[SkipVought]

[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]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dippncope]

Thanks Skip and kjv1611. I have never been disappointed with this site or its people.