Excel Array Formula

[ziad alsayed]

dear all

please is an array formula (CTRL+SHIFT+ENTER), is it possible to make i smaller

Appreciate any help

=SUM(VLOOKUP($A5,'PHC 2011'!$A:$CH,MATCH(CONCATENATE($A$1,C$4),CONCATENATE('PHC 2011'!$3:$3,'PHC 2011'!$4:$4),0),0),VLOOKUP($A5,'Apapa 2011'!$A:$CH,MATCH(CONCATENATE($A$1,C$4),CONCATENATE('Apapa 2011'!$3:$3,'Apapa 2011'!$4:$4),0),0),VLOOKUP($A5,'VI 2011'!$A:$CH,MATCH(CONCATENATE($A$1,C$4),CONCATENATE('VI 2011'!$3:$3,'VI 2011'!$4:$4),0),0),VLOOKUP($A5,'Kano 2011'!$A:$CH,MATCH(CONCATENATE($A$1,C$4),CONCATENATE('Kano 2011'!$3:$3,'Kano 2011'!$4:$4),0),0),VLOOKUP($A5,'Ikeja 2011'!$A:$CH,MATCH(CONCATENATE($A$1,C$4),CONCATENATE('Ikeja 2011'!$3:$3,'Ikeja 2011'!$4:$4),0),0))

 

[jeffreybrown]

You can load it to a site like box.net and leave the link here.

 

[ziad alsayed]

dear Jeff, below is the link

http://www.box.net/shared/y2uhvgiy5j

you can also send to the below email

ziad.alsayed@jubailibros.com


thanks in advance.