Updating a cell from a list selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excelquestioner - 07 Feb 2008 18:11 GMT

I have a supply request form that has a picklist for the user initials and
when that is selected I would like another cell to populate with the user's
email address as a link so that the receiver can simply click on it when
their items arrive and let them know they are in.

I am using the VLOOKUP command to get it to fill in the email address and it
works well but it goes in as text and not as a linked email address.

Thoughts ?

Reply to this Message

Ron Coderre - 07 Feb 2008 18:23 GMT

Try this:

With A2 containing the UserID

This formula generates a link that creates an
email in the default email program:
B2: =IF(A2<>"",HYPERLINK("mailto:"&VLOOKUP(A2,your_list,2,0),
"Click to email"),"")

Replace: your_list
with the actual reference to your lookup table.

Does that help?

------------------------
Regards,

Ron
Microsoft MVP (Excel)
(xl2003, XP Pro)

>I have a supply request form that has a picklist for the user initials and
> when that is selected I would like another cell to populate with the
[quoted text clipped - 7 lines]
>
> Thoughts ?

Reply to this Message