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

**jacksum** · 06-19-2015, 02:35 PM

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** · 06-19-2015, 02:48 PM

Try:

Formula:

Please Login or Register  to view this content.

**jacksum** · 06-19-2015, 02:54 PM

Hi skywriter,

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

**skywriter** · 06-19-2015, 02:56 PM

Originally Posted by jacksum

Hi skywriter,

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

Thanks.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Index/ Match Formula, How to return blank cell as a blank not 0

Make COUNTIF function return blank cell if no data is there

[SOLVED] Return blank cell for formula is there's a match in a column?

[SOLVED] Make a IF formula return a REAL blank cell if false

Help with formula to make cell return a blank

Bookmarks

Bookmarks

Posting Permissions