automating linking icons to different hyperlinks
I use vlookup alot for extracting info from a table of chemical data. For
each chemical i have a chemical data tabulated including a web address for safety data for each entry. On a separate sheet, I use vlookup to extract data to a summary page for selected chemicals from the master sheet. The selected chemicals change all the time. I would like to automate a link to icons on the summary page for each selected chemical so that it automatically looks to the desired safety data hyperlink (in the chemical data table) and can access the webpage for safety data when pressed. I know I can manually attach the hyperlink, but i would like to automate the task as the selected chemicals as the chemicals on the summary sheet change often and updating each link manually would be tedious. Can anyone help? |
automating linking icons to different hyperlinks
Hi Roger
Obviously you are used to using Vlookup. For the cell where you want the hyperlink to be, just warp your normal Vlookup inside HYPERLINK() =HYPERLINK(VLOOKUP(A1,Sheet1$A$1:$G$100,7,0)) -- Regards Roger Govier "Roger on Excel" wrote in message ... I use vlookup alot for extracting info from a table of chemical data. For each chemical i have a chemical data tabulated including a web address for safety data for each entry. On a separate sheet, I use vlookup to extract data to a summary page for selected chemicals from the master sheet. The selected chemicals change all the time. I would like to automate a link to icons on the summary page for each selected chemical so that it automatically looks to the desired safety data hyperlink (in the chemical data table) and can access the webpage for safety data when pressed. I know I can manually attach the hyperlink, but i would like to automate the task as the selected chemicals as the chemicals on the summary sheet change often and updating each link manually would be tedious. Can anyone help? |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com