I will try to explain this as best I can.. I have a workbook with a worksheet filled with hyperlinks; (Formulas sheet). I have a second sheet (Triage PCN's PDN's) that has countless hyperlink functions referencing the Formulas sheet. I now have a third sheet (Search) using vlookup functions to display information from Triage PCN's PDN's, related to information I type into a cell (M3) on the Search sheet. This all works great, but the information being displayed on the Search sheet does not include hyperlinks, just text. I would like it to include the hyperlinks. Is it possible to do this without using script? I am trying to avoid people having to click enable macros, as this will be used by hundreds of people, and some are bound to click disable macros. Any help is appreciated. Thanks.

Here are some example formulas:
=HYPERLINK(Formulas!B2, "Yes") - Example from Triage PCN's PDN's sheet

=IF(M3="", "Type in the PCN and hit enter",IF(ISNA(VLOOKUP(M3,'Triage PCN''s PDN''s'!A2:E1600,4,FALSE)),"No Results Found",VLOOKUP(M3,'Triage PCN''s PDN''s'!A2:E1600,4,FALSE))) - Example from Search sheet