![]() |
#2
|
||||
|
||||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gebobs | Excel | 1 | 08-03-2016 03:10 PM |
how to update calculated fields | sectionbreak | Mail Merge | 4 | 06-04-2014 12:12 AM |
![]() |
MariaAdc | Excel | 1 | 03-01-2011 02:44 AM |
![]() |
Ziggy-R | Word | 10 | 09-28-2010 01:42 AM |
Using calculated field - WHY IS IT SO COMPLICATED? | Riorin | Word | 0 | 10-30-2009 12:20 PM |