hyperlink
3 TopicsCannot concatenate a hyperlink from another cell
I am working with office 365 and I have done this in previous versions but its not working now. I have a site with a html pages like 1.html, 2, html etc. If I write in a cell www.mysite.com/1.html the link works fine if I have a list of numbers in column a and column be is any of the following: ="www.mysite.com/" & a2 & ".html" =hyperlink("www.mysite.com/" & a2 & ".html",a2) =hyperlink("www.mysite.com/" & indirect("a2") &".html",a2) The link is not formed properly. Even in the case of the first if I copy and paste values the spreadsheet shows www.mysite.com/1.html but when I click on it I get an error "cannot connect to www.mysite.com/a2.html Is this a bug or am I missing something. Haim KatzSolved8.2KViews0likes4CommentsExcel Hyperlink and Vlookup
Hello, I have a hyperlink on one tab of a workbook. I need the link to copy to another page based on a key identifier. I have been using vlookup to move data to the front page for the rest of the fields, but the hyperlink has me stumped! =VLOOKUP($C121,'Projected Wires'!$A:$R,18,FALSE) returns the link text...ish.804Views0likes0Comments