Dynamic Hyperlink?

[Russ Berrie]

Hi Guys,
I have got a folder full of pictures relationg to country, Im in the process of making a standard sheet for all my countrys details including an image now. Is there a way to make a Dynamic hyperlink like shown? Where all is hard Data Excluding the green text that relates to a cell including a country name matching what the image file is called?

=HYPERLINK("#"&"H:\Shipping\Export\Archive & Statistics\Country Maps\"&C3,"Image")

 

[Andrew Poulsom]

Did you try it? I don't think you need the # at the beginning.

 

[Russ Berrie]

Hi Indeed you were correct and i needed to add on the end fro the file type so this works for me

=HYPERLINK("H:\Shipping\Export\Archive & Statistics\Country Maps\"&C3&".gif","Image")

Thank you