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?
برچسب:
نویسنده: استخدام کار