Sounds like you just need the appropriate format. Select one of the cells
with the mailto hyperlink from sheet 2, and copy (ctrl+C). Highlight the
column on sheet1 where the email addresses will be returned, then Edit
Paste Special, and select the 'Formats' radio button and click OK.
--Bruce

"youth" wrote:

Hi,
I have a vlookup formula in sheet 1 and in sheet 2 with the list of
names column A and column B with their respective email addresses.

I had the email addresses with hyperlinks in sheet 2.
But when I look up a name on sheet 1, it's not hyperlinked.
I tried hyperlinking it on sheet 1 but when I type in a different name
the email address does not change with the corresponding name.

thanks
youth