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?

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" <(E-Mail Removed)> wrote in message
news:C1686109-DA19-4F0E-BD18-(E-Mail Removed)...
>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?
>
>