What do you mean by "stopped working"? I can't see anything there that would
make it stop working. Did you array enter it?



--
Regards,

Peo Sjoblom


"ruchie" wrote in message
oups.com...
max,
i ran into problem with the formula
is suddenly stopped working after i changed the data set a bit
ive been using this formula:

=INDEX(X!D3:D106,MATCH(1,(X!A3:A106=$A5)*(X!B3:B10 6="Flat/Tier/Step
Average"),0))

Could you tell me what the problem could be?