Activate a hyperlink

I'm reading a hyperlink into a spreadsheet using an =index,match,match formula. The Hyperlink appears as the correct one when you read it in the cell, but it does not link to that address.

A workaround is supposed to be

Select cell
F2
Enter

But that doesn't seem to work either.

Any ideas?

Thanks