Hyperlink

J

JJ

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

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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word hyperlinks not working 2
Hyperlink fails to open on the first click 0
You'll need a new app to open this about link 1
Converting URLs in comments to Markdown-formatted links 2
Shortcuts in OneDrive 0
Hyperlinking automatic?? 1
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top