One way is to use the HYPERLINK function

=HYPERLINK("mailto:" & VLOOKUP(1,A1:B10,2),VLOOKUP(1,A1:B10,2))

If this post helps click Yes
---------------
Jacob Skaria


"bsharp" wrote:

I am using lookup to retrieve email addresses from another workbook.

When I simply type in an email address manually, it becomes a "hot" link,
where I just click on it, and it will open up a new email window in Outlook
with that email address in the to: field.

But when I use the lookup function, the email address doesn't work this way.
All that happens when I click on it is that I select that cell.

Any way I can have these turn back to hot links?

I've tried inserting a hyperlink, but that's more work than just copying and
pasting the email address into OL.