Unable to perform the index and multiple match array function

  • How about

    =INDEX($Q$38:$T$296,MATCH(1,(V38=$R$38:$R$296)*($W$37=$Q$38:$Q$296),0),MATCH($X$37,$Q$37:$T$37,0))

    Or a non array version

    =INDEX($Q$38:$T$296,MATCH(W$37&"|"&V38,INDEX(Q$38:Q$296&"|"&$R$38:$R$296,0),0),MATCH($X$37,$Q$37:$T$37,0))

    It worked. Thanks a lot. But I am unable to understand how this formula works. Could please explain in brief?

  • royUK

    Changed the title of the thread from “Unable to perform the inded and multiple match array function” to “Unable to perform the index and multiple match array function”.