Hi,

One way is to repeat the criteria for the lookup_array as well:

=INDEX('Current Month'!$A:$AN,MATCH(LARGE(IF('Current Month'!$AM:$AM<>"X",IF('Current Month'!$F:$F=$A$29,IF('Current Month'!$AJ:$AJ="Increase",'Current Month'!$AI:$AI))),$A39),IF('Current Month'!$AM:$AM<>"X",IF('Current Month'!$F:$F=$A$29,IF('Current Month'!$AJ:$AJ="Increase",'Current Month'!$AI:$AI))),0),1)

Regards