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

--
Jacob (MVP - Excel)


"JJ" wrote:

Can I use hyper link in one cell but link to more than one external data
files? If not, how can it be done?