excel_training_wheels
Board Regular
- Joined
- Aug 25, 2005
- Messages
- 193
Hi--
I have a workbook with hyperlinks included. I would like to VLOOKUP and have the underlying URL returned, rather than the hyperlink. Is there a way to do that?
--OR--
Is there a way to convert the entire column of hyperlinks to just have the URL, and then my VLOOKUP will be fine.
In otherwords, I want to see http://...... instead of E09887.htm when the lookup is complete.
Please help!
I have a workbook with hyperlinks included. I would like to VLOOKUP and have the underlying URL returned, rather than the hyperlink. Is there a way to do that?
--OR--
Is there a way to convert the entire column of hyperlinks to just have the URL, and then my VLOOKUP will be fine.
In otherwords, I want to see http://...... instead of E09887.htm when the lookup is complete.
Please help!