I have created a drop down list in excel cell A1 which contains a validated
list from cells D1 through D3. The values of D1 through D3 are cat, puppy,
and parrot respectively. Cells E1 through E3 contains hidden values which I
want to substitute later. These values are feline, dog and bird respectively.

So, if the user chooses "cat" from the drop-down, I want to do something
like =CONCATENATION($A1,"http://www.petsite.org/",????????????) that will
result in the cell containing http://www.petsite.org/feline as a hyperlink.
Obviously if the user puppy or parrot the respective entry would be
substituted.

Thanks in advance, Royce

Try this...

Use cell B1 as the hyperlink.

Enter this formula in B1:

=IF(A1="","",HYPERLINK("http://www.petsite.org/"&VLOOKUP(A1,D1:E3,2,0)))

--
Biff
Microsoft Excel MVP


"Royce Edwards" <Royce wrote in message
...
I have created a drop down list in excel cell A1 which contains a validated
list from cells D1 through D3. The values of D1 through D3 are cat,
puppy,
and parrot respectively. Cells E1 through E3 contains hidden values which
I
want to substitute later. These values are feline, dog and bird
respectively.

So, if the user chooses "cat" from the drop-down, I want to do something
like =CONCATENATION($A1,"http://www.petsite.org/",????????????) that will
result in the cell containing http://www.petsite.org/feline as a
hyperlink.
Obviously if the user puppy or parrot the respective entry would be
substituted.

Thanks in advance, Royce