Hey guys,

I have a worksheet that sets a hyperlink depending on a cell drop down entry, my problem is the hyperlinks to a certain website throw back the "Unable to open http://. Cannot download the information you requested" I think it may be the security settings on the particular web site. My code is below, all hyperlinks to the "lysaght" website are the links that don't work, any ideas? Thanks again guys & have a great day - Marco

=IF(C14="Select","",IF(C14="N/A","",IF(C14="Maxirib",HYPERLINK("https://www.stratco.com.au/home/products/home-improvement-product-template/?product=30&","Standard Colorbond Range"),IF(C14="Custom Orb",HYPERLINK("http://www.lysaght.com/products/custom-orb","Standard Colorbond Range"),IF(C14="Maxirib Ultra",HYPERLINK("http://www.steelselect.com/materials/grade-12-colorbond-ultra-steel","Ultra Colorbond Range"),IF(C14="Custom Orb Ultra",HYPERLINK("http://www.steelselect.com/materials/grade-12-colorbond-ultra-steel","Ultra Colorbond Range"),IF(C14="Mini Orb",HYPERLINK("http://www.lysaght.com/products/mini-orb","Standard Colorbond Range"),IF(C14="Other",("Enter Details"),"Type In: Brand - Colour Name &  Colour Code"))))))))