0
I'm using the following formula in Google Sheets:
=iferror(hyperlink(INDIRECT("'"&I2&", "&H2&"'"),I2),"")
Cells I2 and H2 contain a last name and first name. I have a tab in the file that matches the results of the indirect function and the formula works fine for several rows but does not work for several others. The only difference in the source data is the lengths of the names. For the instances that do not work, the value from I2 is displayed but no link is produced. I get the same result if the iferror function is removed leading me to the conclusion that there is no error condition.
What might prevent the link from being produced?
Paul Kennedy
Posted 2019-05-08T22:10:56.270
Reputation: 1