Where do I put the Hyperlink's friendly name?

[jmpatrick]

I have this formula that I wrote that creates a hyperlink using matched data. I'd like to add a friendly name that appears when I hover over the link but I'm not sure where it would go. Everywhere I try throws an error...

=IFERROR(HYPERLINK(INDEX(Subdivisions!J:J,MATCH(AP462,Subdivisions!C:C,0)),INDEX(Subdivisions!G:G,MATCH(AP462,Subdivisions!C:C,0))),"")

 

[Fluff]

You already have one, it's the 2nd index/match formula

 

[jmpatrick]

You already have one, it's the 2nd index/match formula

My bad! I shouldn't have said friendly name. I'm trying to add a Screen Tip to the formula.

 

[Fluff]

What do you mean a "Screen tip"?

 

[RoryA]

There is no option for that with the HYPERLINK function.

 

[jmpatrick]

What do you mean a "Screen tip"?

It's the mouse-over message that pops up. Sounds like it's not possible. Thanks.

 

[Fluff]

But surely that's the same as the friendly name?

 

[jmpatrick]

But surely that's the same as the friendly name?

It's this on my version:

I'm trying to customize it.

 

[Fluff]

AFAIK you cannot customise it & as Rory has said, there isn't a "Screen tip" as such, just the mouse over.

 

[jmpatrick]

AFAIK you cannot customise it & as Rory has said, there isn't a "Screen tip" as such, just the mouse over.

That would be really cool if there was. Thanks.