函数求助

网络人

=IFERROR(INDEX(sheet1!C:C,SMALL(IF(AND(sheet1!C$9:D$63<>"",FIND("抽",sheet1!C$9:D$63)),ROW(sheet1!$9:$63)),ROW(A1))),"")求助这函数错误在那里
=IFERROR(INDEX(sheet1!C:C,SMALL(IF(AND(sheet1!C$9:D$63<>"",sheet1!F$9:F$63<>""),ROW(sheet1!$9:$63)),ROW(A1))),"")这样的错在哪了

qqyyh

应该是数组函数吧，用ctrl+shift+enter。