ignore #num when no data

Lockin

New member
Joined
Oct 28, 2012
Messages
1
Reaction score
0
Points
0
Hi,
I have the below array formula which works fine until it picks up no data when it displays #num error. Is ther any way I can add someting in this formula not to show #num.

Thanks.

=INDEX(DB!$M$2:$M$24077, SMALL(IF($A$1=DB!$B$2:$B$24077,ROW(DB!$B$2:$B$24077)-ROW(DB!$B$2)+1),ROW(DB!1:1)))
 
You could use an =IF(isnumber(cell to check), your current formula, "")
 
Back
Top