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 return #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?


Category: microsoft excel Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.250 (s). 12 q(s)