User Profile
Conor365
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Calling a cell with an embedded hyperlink
NikolinoDE - I adapted the formula (a nice approach for a dynamic search) and unfortunately it's not giving me what I need. It presumes the links in Sheet1 are in the format https:// but unfortunately, they already have friendly names. I'll keep looking! ThanksCalling a cell with an embedded hyperlink
In my workbook, I have one sheet (lets say Sheet1) that has a hyperlink associated with each row. The hyperlink is in the format 123-456-789 (friendly name), and the full hyperlink (Https://...) is embedded in the cell, so if you click the cell displaying the friendly name, you are brought to the external webpage (https://...). These hyperlinks are copied from an external non-Excel source, so I can't easily extract the full hyperlink (that I am aware of), and the friendly names are part of the data source that copy over automatically. In my second sheet (Sheet2) I want to VLOOKUP the row number (e.g. 001-500) and return the column with the hyperlink, and make it clickable. Sheet2 is used as a summary sheet that is emailed out for convenient use. The problem is that the HYPERLINK function in excel would look up the text string displayed in Sheet1 (here, 123-456-789) as dumb text and try to convert it to a hyperlink which is not followable. Is there an easy way to extract the full hyperlink name and use that? Note I do not already have a column of data with the full hyperlinks, and copying these manually over from external data source would be too time intensive, and not maintainable in the future.
