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 ?