Array Substitution Based on Drop Down List
 

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

Array Substitution Based on Drop Down List
 

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