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

Basically, the formula is adding a number it retrieves from $A$398:$HD$460 on
the Data sheet to another number, which it retrieves from $A$462:$HD$524 on
the Data sheet. The sum of these two numbers is divided by a third number
which it retrieves from $A$526:$HD$588 on the Data sheet.

It uses the INDEX function to get each of the 3 numbers. The arguments for
INDEX are the array (range) where the data is located, the row number to use,
and the column number to use (the value of the cell at the intersection of
the specified row & column is returned). The MATCH function is used to find
the correct row; it always looks for an exact match to the value in Z11 on
the sheet containing this formula. Another MATCH is used to find the correct
column; it always looks for an exact match to the value in C2 on the Current
Month sheet.

The formula is so long because it is repeated twice within the IF(ISERROR
construction. The INDEX and MATCH functions are all evaluated; if any errors
are returned, the formula returns zero ( ,0, ). If no errors are returned,
the INDEX and MATCH functions are evaluated again and the resulting value is
returned.

Hope this helps,

Hutch

"geebee" wrote:

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