Negate INDEX/MATCH result based on another Cell

[BrizzleC]

Slowly getting there with this VBA/Excel "Magic" but stuck with this problem:


I have an INDEX/MATCH formula which returns the results for Min values, based on the input criteria as shown

=INDEX($L$73:$S$90,MATCH($R$10,$J$73:$J$90,0),MATCH($N$4,$L$72:$S$72,0))


However, I wondered if there was a way I can adjust this to negate the values if $D10 = "Loss"?


Many Thanks All for any help/suggestions.

 

[Oeldere]

=if(d10="Loss","",your formula)

 

[BrizzleC]

Thanks, but this returns a blank and I need the returned value to be negative when its a "loss".

 

[Jonmo1]

Try

=INDEX($L$73:$S$90,MATCH($R$10,$J$73:$J$90,0),MATCH($N$4,$L$72:$S$72,0))*IF($D10="Loss",-1,1)

 

[BrizzleC]

Fabulous Work!

Thanks ever so much

 

[Jonmo1]

You're welcome.