Forum Discussion
Hyperlink Cells with VLOOKUP
I have cells with initials and hyperlinks to email addresses that open in Outlook, include any necessary Ccs, and include the subject. On another worksheet within the same workbook I have cells that ...
Your VLOOKUP will return the value of S2, i.e. the initials. That is not valid as a hyperlink, of course.
If you enter the hyperlink addresses in column F of the FL Email sheet, you could use
=IFERROR(HYPERLINK(VLOOKUP(S2,'FL Email'!$E$2:$F$100,2,FALSE)),"")