Can someone help "IFERROR" this formula for me?

[alexx579]

Hi all, I have a formula I am using to create a listing (no blanks). Unfortunately, I can't get iferror to return a blank if there is an #N/A. Can someone help?

=IF(INDEX(NotOnMasterList,SMALL((IF(LEN(NotOnMasterList),ROW(INDIRECT("1:"&ROWS(NotOnMasterList))))),ROW(A1)),1)=0,"",IFERROR(INDEX(NotOnMasterList,SMALL((IF(LEN(NotOnMasterList),ROW(INDIRECT("1:"&ROWS(NotOnMasterList))))),ROW(A1)),1),""))

Thanks!!!!~~~~

 

[Marcelo Branco]

Could you provide a small data sample along with expected results?

M.