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