Error Response

[Mr Noodle]

Hi guys, I need some help, I am using the following array formula:


=INDEX(tbl,SMALL(IF(COUNTIF(search_tbl,INDEX(tbl,,1,1))>0,ROW(tbl)-MIN(ROW(tbl))+1),ROW(A8)),5)


This works great, but in instances where there is nothing to report, it fills the cell with a #num! response.
I have tried a million ways, but cannot seem to find the right solution, how do I get rid of the #num! response and just report a blank cell when there is no information to display?
Thanks in advance.

 

[tusharm]

Check Excel help for the IFERROR function.

Hi guys, I need some help, I am using the following array formula:


=INDEX(tbl,SMALL(IF(COUNTIF(search_tbl,INDEX(tbl,,1,1))>0,ROW(tbl)-MIN(ROW(tbl))+1),ROW(A8)),5)


This works great, but in instances where there is nothing to report, it fills the cell with a #num! response.
I have tried a million ways, but cannot seem to find the right solution, how do I get rid of the #num! response and just report a blank cell when there is no information to display?
Thanks in advance.

 

[Mr Noodle]

Thank you for that, thats a great suggestion. I have tried, but for some reason I cannot get it to work with IFERROR. Perhaps I am reworking the formula incorrectly or getting the context incorrect?

 

[tusharm]

What did you do and how did it not work?

Thank you for that, thats a great suggestion. I have tried, but for some reason I cannot get it to work with IFERROR. Perhaps I am reworking the formula incorrectly or getting the context incorrect?