Excel functions such as VLOOKUP, INDEX, INDIRECT are generally used to search and copy /paste cells from within the worksheet or other worksheets. These functions will bring all the attributes of the cell content except the Hyperlink. Is there an excel function that will read another cell and copy it with the Hyperlink? I do not know anything about Visual Basic, so if the answer is in that form, please tell me how to install the code.
Thanks for your help.
hndharia
Hi,
Use the hyperlink function like this:
=HYPERLINK(VLOOKUP(1;A1:B3;2))
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks