I have this formula that I wrote that creates a hyperlink using matched data. I'd like to add a friendly name that appears when I hover over the link but I'm not sure where it would go. Everywhere I try throws an error...
Excel Formula:
=IFERROR(HYPERLINK(INDEX(Subdivisions!J:J,MATCH(AP462,Subdivisions!C:C,0)),INDEX(Subdivisions!G:G,MATCH(AP462,Subdivisions!C:C,0))),"")