Array Formula In IF Function

[guochingsu]

Hello,

I have an array formula as follows:

{=INDIRECT("F"&SMALL(IF(E$8:E$22=$N$7,ROW($8:$22)),ROW()-8))}

the formula work fine, but it I put it into IF function to set the conditions display blank instead of #NUM! if the array formula does not have correct value:

{=IF(ISERROR(INDIRECT("F"&SMALL(IF(E$8:E$22=$N$7,ROW($8:$22)),ROW()-8))),"",INDIRECT("F"&SMALL(IF(E$8:E$22=$N$7,ROW($8:$22)),ROW()-8)))}

it seems that the original array formula won't work, so always show blank.

Any help?

Thanks