LinkBack URL
About LinkBacks
you can use below enter in D2 and drag down
=IFERROR(SUMPRODUCT((lookup!$B$7:$B$9=INDEX(C:C,MATCH(MAX($B$2:B2),B:B,0)))*(MID(C2,FIND(":",C2)+2,100)=lookup!$M$5:$O$5)*lookup!$M$7:$O$9),"")
you can use below enter in D2 and drag down
=IFERROR(SUMPRODUCT((lookup!$B$7:$B$9=INDEX(C:C,MATCH(MAX($B$2:B2),B:B,0)))*(MID(C2,FIND(":",C2)+2,100)=lookup!$M$5:$O$5)*lookup!$M$7:$O$9),"")
Last edited by hemesh; 01-08-2016 at 11:23 AM. Reason: Uploaded file!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks