Formula that creates Hyperlinks based on Match...but not when no Match is found.

[jmpatrick]

Good morning!

I use this formula to create a hyperlink by matching values from a source column to a column on another Sheet. Works great except that it creates a hyperlink even if no match is found. I can't figure out how to change it so that no hyperlink is created if no match is found. Here's my formula:

=IFERROR(HYPERLINK(INDEX(Subdivisions!J:J,MATCH(AI5,Subdivisions!C:C,0)),INDEX(Subdivisions!G:G,MATCH(AI5,Subdivisions!C:C,0))),"")

 

[Fluff]

How about

=LET(m,MATCH(AI5,Subdivisions!C:C,0),IF(ISNA(m),"",HYPERLINK(INDEX(Subdivisions!J:J,m),INDEX(Subdivisions!G:G,m))))

 

[jmpatrick]

How about

=LET(m,MATCH(AI5,Subdivisions!C:C,0),IF(ISNA(m),"",HYPERLINK(INDEX(Subdivisions!J:J,m),INDEX(Subdivisions!G:G,m))))

This works, but the cell still appears to have a hyperlink (even if clicking it does nothing). Is that something I have to live with?

 

[Fluff]

Is that something I have to live with?

As far as I know, yes.

 

[jmpatrick]

As far as I know, yes.

Thanks!

 

[Fluff]

You're welcome.