hyperlinks from a list? using excel 2000
 

jacob

Okay, I'll get right to the issue.

I'm using the List feature of Data Validation in A1, with a range of
names on the Z file. The list contains a name and telephone number and
email address. What I'm trying to do is insert an email hyperlink in
that same cell so when a List item is chosen from the drop down list,
you can click on A1 to send an email address. The email hyperlink
would
need to change along with the name.
I don't think this will work, so what about creating a clickable link
in A2 that changes with the data that is displayed in A1?


My last resort would be to create a pivot table, which I am TERRIBLY
inexperienced at doing.


Please help!


-Jacob

You could use a formula to display the hyperlink in an adjacent cell.
For example, with the data validation list in cell E2:

="Mailto:"&HYPERLINK(VLOOKUP(E2,$A$1:$B$100,2,0),E 2)

where the list of names and email addresses is in A1:B100

jacob wrote:
jacob

Okay, I'll get right to the issue.

I'm using the List feature of Data Validation in A1, with a range of
names on the Z file. The list contains a name and telephone number and
email address. What I'm trying to do is insert an email hyperlink in
that same cell so when a List item is chosen from the drop down list,
you can click on A1 to send an email address. The email hyperlink
would
need to change along with the name.
I don't think this will work, so what about creating a clickable link
in A2 that changes with the data that is displayed in A1?


My last resort would be to create a pivot table, which I am TERRIBLY
inexperienced at doing.


Please help!


-Jacob







--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Your formula created a link for me, but it didn't look like a link
(blue/underline).

This does the same thing and looks like a link:

=HYPERLINK("Mailto:"&VLOOKUP(E2,$A$1:$B$100,2,0),E 2)

Actually, the "mailto:" portion shows up in Debra's formula, but not in that
second version.

Debra Dalgleish wrote:

You could use a formula to display the hyperlink in an adjacent cell.
For example, with the data validation list in cell E2:

="Mailto:"&HYPERLINK(VLOOKUP(E2,$A$1:$B$100,2,0),E 2)

where the list of names and email addresses is in A1:B100

jacob wrote:
jacob

Okay, I'll get right to the issue.

I'm using the List feature of Data Validation in A1, with a range of
names on the Z file. The list contains a name and telephone number and
email address. What I'm trying to do is insert an email hyperlink in
that same cell so when a List item is chosen from the drop down list,
you can click on A1 to send an email address. The email hyperlink
would
need to change along with the name.
I don't think this will work, so what about creating a clickable link
in A2 that changes with the data that is displayed in A1?


My last resort would be to create a pivot table, which I am TERRIBLY
inexperienced at doing.


Please help!


-Jacob






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

I got the blue underline with my formula (Excel 2002), but yours, with
the hidden MailTo, is better.
(Pre-caffeine. That's my excuse, and I'm sticking to it.)

Dave Peterson wrote:
Your formula created a link for me, but it didn't look like a link
(blue/underline).

This does the same thing and looks like a link:

=HYPERLINK("Mailto:"&VLOOKUP(E2,$A$1:$B$100,2,0),E 2)

Actually, the "mailto:" portion shows up in Debra's formula, but not in that
second version.

Debra Dalgleish wrote:

You could use a formula to display the hyperlink in an adjacent cell.
For example, with the data validation list in cell E2:

="Mailto:"&HYPERLINK(VLOOKUP(E2,$A$1:$B$100,2,0),E 2)

where the list of names and email addresses is in A1:B100

jacob wrote:

jacob

Okay, I'll get right to the issue.

I'm using the List feature of Data Validation in A1, with a range of
names on the Z file. The list contains a name and telephone number and
email address. What I'm trying to do is insert an email hyperlink in
that same cell so when a List item is chosen from the drop down list,
you can click on A1 to send an email address. The email hyperlink
would
need to change along with the name.
I don't think this will work, so what about creating a clickable link
in A2 that changes with the data that is displayed in A1?


My last resort would be to create a pivot table, which I am TERRIBLY
inexperienced at doing.


Please help!


-Jacob






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html