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.

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)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

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.

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post