INDEX
hi,
i am looking at a report that i am trying to interpret... the following
formula is in the
=IF(ISERROR((INDEX(Data!$A$398:$HD$460,
MATCH(Z11,Data!$A$398:$A$460,FALSE),
MATCH('Current
Month'!$C$2,Data!$A$398:$HD$398,FALSE))+INDEX(Data !$A$462:$HD$524,
MATCH(Z11,Data!$A$462:$A$524,FALSE),MATCH('Current
Month'!$C$2,Data!$A$462:$HD$462,FALSE)))/INDEX(Data!$A$526:$HD$588,MATCH(Z11,Data!$A$526:$A $588,FALSE),MATCH('Current
Month'!$C$2,Data!$A$526:$HD$526,FALSE))),0,(INDEX( Data!$A$398:$HD$460,MATCH(Z11,Data!$A$398:$A$460,F ALSE),MATCH('Current
Month'!$C$2,Data!$A$398:$HD$398,FALSE))+INDEX(Data !$A$462:$HD$524,MATCH(Z11,Data!$A$462:$A$524,FALSE ),MATCH('Current
Month'!$C$2,Data!$A$462:$HD$462,FALSE)))/INDEX(Data!$A$526:$HD$588,MATCH(Z11,Data!$A$526:$A $588,FALSE),MATCH('Current
Month'!$C$2,Data!$A$526:$HD$526,FALSE)))
i cant seem to interpret it.
help!
thanks in advance,
geebee
|