excel hyperlink text to display and vlookup

[bluker]

Good Day,

hope that you possibly can help me.

I tried below function in an Excel sheet. It works well until I change the
text to display for the hyperlink, for e.g. to cnn instead of
http://www.cnn.com.

Then the link doesn’t work anymore. For short links this is no issue, but
unfortunately I have major long links to follow
and would love to make them more user friendly by shortening the displayed
text. Is this possible at all?

I seriously appreciate your help.
Thank you and best regards, Kerry

 

[Jacob Skaria]

By the way what is your lookup value (A1). Is that a friendly name like cnn
or so . If so try the below
=HYPERLINK(VLOOKUP(A1,M1:N5,2,FALSE),A1)

OR
have a friendly name for each in Col O1:O5 and then
=HYPERLINK(VLOOKUP(A1,M1:O5,2,FALSE),VLOOKUP(A1,M1:O5,3,FALSE))

If this post helps click Yes

 

[bluker]

Good Day,
this was easy.
I tried both solutions and they both work perfectly.
Thank you so much!
Kerry