admin管理员组

文章数量:1122846

I have been using this formula for several years to return the corresponding value Y for the nth instance of the occurance of value X in numerous spreadsheets and it works perfectly every time: (in this example, it is the 4th occurene of the value in cell D1237)

=INDEX(TCIREV24!$O$2:$O$3039,SMALL(IF($D1237=TCIREV24!$K$2:$K$3039,ROW(TCIREV24!$K$2:$K$3039)-ROW(INDEX(TCIREV24!K$2:$K$3039,1,1))+1),4))

I have been trying to replicate this same basic formula for a different project and have constructed this formula"

=INDEX(DIGIDOC_AMM_TOC!$I$2:$I$25634,SMALL(IF(B3=DIGIDOC_AMM_TOC!$C$2:$C$25634,ROW(DIGIDOC_AMM_TOC!$C$2:$C$25634)-ROW(INDEX(DIGIDOC_AMM_TOC!$C$2:$C$25634,1,1))+1),4))

but all I get for a return is #N/A.

I have tried every trick I know to check and recheck formats, columns, ranges, moving all the data to a fresh workbook, but nothing seems to work. What am I missing?

本文标签： Return the corresponding value Y for the nth instance of the occurence of value X in ExcelStack Overflow

版权声明：本文标题：Return the corresponding value Y for the nth instance of the occurence of value X in Excel - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736305532a1932624.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。