using an Array formula to do VLOOKUP in multiple sheets

I have used below formula in this file but I do not know why it doesn not work and retu #N/A!? Infact I need to lookup "Station .No" from other sheets to display it in Sheet1 :

= VLOOKUP(I3,INDIRECT("'"&INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A$5:$N$500"),I3)>0),0))&"'!$A$5:$N$500"),14,FALSE)

Could you please guide me?

Recent Questions...