|
|
#3
04-06-2017, 11:17 AM
|
|||
|
|||
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. 
Last edited by Harleygal17; 04-06-2017 at 11:18 AM. Reason: fixed type now=not 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Round num_digits calculated?
|
gebobs | Excel | 1 | 08-03-2016 03:10 PM |
| how to update calculated fields | sectionbreak | Mail Merge | 4 | 06-04-2014 12:12 AM |
|
Calculated Field is disabled
|
MariaAdc | Excel | 1 | 03-01-2011 02:44 AM |
|
Calculated dates.
|
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 |
Windows 10 
Office 2016
Threaded Mode