So what I am trying to do is that, I know that I can use a an array formula for the concatenation, but it'll take a very long time in calculating.
So am wondering if there's a better way to get the same result but with faster calculation.
{=INDEX(INDEX('\\network\Shared\folder\[workbook 1.xlsb]wb1ofsheet1'!$A:$ZZ,MATCH($A4,CONCATENATE('\\network\Shared\folder\[workbook 1.xlsb]wb1ofsheet1'!$A:$A,";",'\\network\Shared\folder\[workbook 1.xlsb]wb1ofsheet1'!$C:$C),0),MATCH("For*",'\\network\Shared\folder\[workbook 1.xlsb]wb1ofsheet1'!$2:$2,0)+IF(RIGHT(E$3,6)="Budget",1,0)),)
Bookmarks