I am having trouble with the following formula:
{=SUM(INDEX(Detail!$K$6:$BA$100,MATCH(Walkacross!$L14,Detail!$B$6:$B$100,0),MATCH(Walkacross!V$13&Walkacross!$M14,Detail!$K$4:$BA$4&Detail!$K$5:$BA$5,0)),0)}
I have attached a spreadsheet for details. I got the index(match(match to work properly the problem is happening when suming.
Bookmarks