R
Royce Edwards
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
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