Hello Excel Gurus

i am just trying to create a dynamic formula where user chooses his/her school and years folders in dropdown cells A1 and A2 and these two contribute in formula where data is exctracted from.
The problem here is that i dont know how to make concatenate or & working. if i implement the result of concatenate in formula it works fine

=IFERROR(VLOOKUP(OFFSET($A1,1,MATCH("School name",$1:$1,0))-1,'G:\schools graphs\School1\2014\Report\[Report.xlsx]Tab1'!$Y$2:$AV$120008,24, FALSE),"")

but not when it looks like that
=IFERROR(VLOOKUP(OFFSET($A1,1,MATCH("School name",$1:$1,0))-1,CONCATENATE("G:\schools graphs\",A1,"\",A2,"\Report\[Report.xlsx]Tab1'!","$Y$2:$AV$120008"),24, FALSE),"")

or that
=IFERROR(VLOOKUP(OFFSET($A1,1,MATCH("School name",$1:$1,0))-1,"'G:\schools graphs\"&A1&"\"&A2&"\Report\[Report.xlsx]Tab1'!"&"$Y$2:$AV$120008"),24, FALSE),"")

Any ideas on how to make it working?

Thank you for any help