Updating a cell from a list selection
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 ? |
Updating a cell from a list selection
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_lis t,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) "Excelquestioner" wrote in message ... 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 ? |
All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com