Feb 09 2023 10:34 AM
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 show the same initials based on a separate database report. I want to lookup the initials and return the hyperlinked initials.
My current formula returning, "Cannot open the specified file.":
=IFERROR(HYPERLINK(VLOOKUP(S2,'FL Email'!$E$2:$E$100,1,FALSE)),"")
(S2,= data import showing initials to send email to
'FL Email'!$E$2:$E$100 = area where initials with hyperlinked data is stored
Is HYPERLINK going to work since I don't need to 'build' a hyperlink? Is there an actual way to do this?
Feb 10 2023 04:42 AM
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)),"")