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

 

[SkipVought]

Hi,

First, you have asked a question related to native Excel, best handled in Forum68.

Check out the HYPERLINK function. That should work for you.

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

 

[dippncope]

Thank you I will post there