automating linking icons to different hyperlinks

[Roger on Excel]

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.

 

[Roger Govier]

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))