Add external hyperlink to a calculated number

[Harleygal17]

I am trying to add a hyperlink (any hyperlink external to data on the spreadsheet) in a cell that has a formula for a calculated number. For instance, something as simple as =B4*C4. When the number is displayed I want to be able to add a hyperlink to some external content so the user can look at the details from another system.



For purposes of my example, if the calculated number is "5" (formatted as number), I want it (5) to appear as a hyperlink and take me to: https://www.msofficeforums.com.

I've tried a few simple things and searched the web but haven't found anything that seemed applicable. Any ideas from anyone?

FYI: I am using Excel 2016.

[Pecoflyer]

Perhaps create a small table with the numbers in the first column and in the second column the hyperlink as text
Say this table is T1:U10
Then in your cell with calculated number enter =hyperlink(vlookup(B4*C4,T1;U10;2;0))
(B4*C4 is the formula you showed, any formula should work)

[Harleygal17]

Thanks for getting me pointed in the proper direction. Although the formula wasn't exactly what I was looking for, it got me going in the correct direction and I was able to figure it out from there.

The formula I ended up using that worked is: =hyperlink(vlookup(A2,F1:G5,2,0)),B2*C2)

Here is the data in my spreadsheet that corresponds to the formula:
Calc'd Number with Hyperlink.PNG

Thanks again for the help! I'm not a novice at Excel but I'm also not a "power" user. I fall somewhere in the mediocre middle.

[Harleygal17]

This formula also worked by basically "hard-coding" the URL rather than using VLOOKUP. Either way could work based on the need(s).

Calcd Number w Hyperlink.PNG

Next hurdle is getting it to work in our Confluence spreadsheet add-on.
Thanks again.

[Pecoflyer]

Glad you found your answer. Please mark the thread solved ( click the "Thread tools" drop down)