• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Having trouble with an INDEX MATCH

Busymanjohn

Busymanjohn

Member
Hi, having some problems, my own logic says I should use INDEX and MATCH for this, but it doesn't give me the desired results, so I am either doing something wrong or INDEX MATCH just won't work in this instance ,,,,, explained in the attached file ,,, please reply via here with the corrected formula ,,, also having trouble retrieving files from rapidshare. Thanks.


http://rapidshare.com/files/444246918/Poser_2.xls
 
John

Try this in C18 and copy to fill the report area:

=OFFSET($C$2,SUMPRODUCT(($B$3:$B$14=$B18)*($C$3:$C$14=C$17)*(ROW($3:$14)-2)),MATCH($B$16,$D$2:$O$2))
 
Offset or Index with Sumproduct or Match can just about do anything and the effort learning them is well worth the results you can achieve

Pull the above equation apart as a start and try and understand what each bit does by itelf and then how it all works together.
 
You must log in or register to reply here.
Back
Top