Thread: INDEX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default 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