Wouldn't let me post it to forum for some reason.
SamT,
I don't know why this wouldn't post as a reply to forum. Maybe It will let me send you a DM.
B3 has a TEXT cell with numbers that start with "0". Such as "012553578". I want to be able to click this B3 cell or double click and have it bring me to a specific URL that is stored in T3.
T3 has a formula pulling this URL from another workbook.
T3 contains this formula: =VLOOKUP($B3,'C:\Users\1260948764C\Documents\Loggie Tools\Supportability Analysis\May 2016 Supportability\[Weapon System Asset Availability Constraint Slicer.xlsm]NIIN Detail'!$C$1:$BR$30000,45,FALSE).
It returns a url starting with "http://" value in that cell. I'd write the entire url out but the forum will not allow me to.
Thanks for any advice.