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?