You need to use the HYPERLINK function or a macro

=IF(ISNA(MATCH(A1,Sheet2!A2:A30,0)),"",HYPERLINK(" mailto:"&VLOOKUP(A1,Sheet2!A2:B30,2,0),VLOOKUP(A1, Sheet2!A2:B30,2,0)))

replace the vlookup formula with your formula and the match range with the
leftmost range in your vlookup formula

--
Regards,

Peo Sjoblom

(No private emails please)


"youth" wrote in message
oups.com...
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