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.