Linking email address to a specific DropDown List value

Hi,

I'm new to this forum so hello everybody.

I need help (BADLY) in order to create an Internal Complaints Spreadsheet.

I created a drop-down list (from a different spreadsheet) of all the agents in the company I work for, so I can select the right agent according to the complaint.

HERE'S THE PROBLEM : I want to link an email account to each of the agents (values) so when I select 1 agent (from the drop-down list) on my primary spreadsheet, the email address linked to him/her shows up in the cell next to his/her name.

The reason for this is I want to then create a hyperlink that I can click on to send an email.

Can someone please help me!!?!???

Thanks a lot

Hy there! I'm new too on this forum..but let's see if I can help. I don't know if I understood corectly, but I think vlookup should do the trick. See attachment.

Could you just use a vlookup or hlookup? If so, you can do something like the formula below. The vlookup formulas would need to be filled out so that it looks at the person's name and pulls their email address. The second vlookup is what the cell will display, the first one creates the actual link to create the email.

Please Login or Register  to view this content.

Nice snax! Good post!

Thanks a lot guys that was very helpful.

Unfortunately, I ran into another problem...

I created a "mailto:" hyperlink, but it keeps giving me the same error because of the title of the Hyperlink. I want to see "SEND EMAIL" in the cell so I can click on it to generate the email (Outlook)

Here's the URL

=HYPERLINK("mailto:[email protected]?subject=ALERT 3185&body=SHOP%20%3A%0D%0A%E2%80%A2%09"&C3&"%0D%0A%0D%0AFILE%20%3A%0D%0A%E2%80%A2%09"&D3&"%0D%0A%0D%0AAGENT%20%3A%0D%0A%E2%80%A2%09"&E3&"%0D%0A%0D%0AFEEDBACK%20%3A%0D%0A%E2%80%A2%09"&G3&"%0D%0A, "SEND EMAIL")

The decoded version of the body would be (FYI):

SHOP :
• (Cell C3)

File :
• (Cell D3)

AGENT :
• (Cell E3)

FEEDBACK :
• (Cell G3)


Keeps trying to correct the formula with ; ""SENDEMAIL") at the end but even if I correct it (MS autocorrect), still gives me the #VALUE error...

Can somebody help me with this??

Try using this formula.

Please Login or Register  to view this content.

Thanks SNAX it worked perfectly