Formula to Make Match Function Return a Blank Cell instead of #N/A error for Hyperlinks

[jacksum]

Hi,

I have a worksheet that is currently creating hyperlinks for search results that were found using the MATCH function (Column F).
If there is no data reference, the results show a #N/A.
I would like the worksheet to return a blank cell instead of the #N/A sign.

The formula I am currently using is:

Please Login or Register  to view this content.

However, it does not work. Please see attached. Thank you for your help!
Test.xlsm

[skywriter]

Try:

Please Login or Register  to view this content.

[jacksum]

Hi skywriter,

Thanks for your help again! Two days in a row. Works perfectly.

[skywriter]

Hi skywriter,

Thanks for your help again! Two days in a row. Works perfectly.

Thanks.