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.":
(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?