Hi,

I changed the second formula to:
=IF(D$5=Summary!$B$1,INDEX(Summary!$B$10:$E$136,MATCH($C7,Summary!$B$10:$B$136,0),3),"")
to pick up the budget file.

These formulas work for "Branch1" however when I copy it down to Branch2 and Branch3 it doesnt change - is there a way to match the branch?