INDEX MATCH MIN Formula

Hi,

In B2 and copied down,

Formula:

=MIN(IF(($A2=Results!D:D)*(Results!L:L>0),Results!L:L))

This is an array formula and as suck should be confirmed with CTRL, SHIFT and enter. Done correctly it will display thus:

Formula:

{=MIN(IF(($A2=Results!D:D)*(Results!L:L>0),Results!L:L))}

Note, using arrays will full columns or rows will slow your workbook down considerably. Consider using specific ranges to limit the number of cells that are calculated.

eg;

Formula:

=MIN(IF(($A2=Results!$D$2:$D$20000)*(Results!$L$2:$L$20000>0),Results!$L$2:$L$20000))