J JJ Apr 26, 2010 #1 Can I use hyper link in one cell but link to more than one external data files? If not, how can it be done?
Can I use hyper link in one cell but link to more than one external data files? If not, how can it be done?
J Jacob Skaria Apr 26, 2010 #2 If you mean to display multiple links in the same cell based on a condition then Yes; as below... =HYPERLINK(IF(B1="Yes","c:\1.txt","c:\2.txt"))
If you mean to display multiple links in the same cell based on a condition then Yes; as below... =HYPERLINK(IF(B1="Yes","c:\1.txt","c:\2.txt"))
