Find Minimum and Return a Figure

[Paul Black]

Good morning,

I have in column i from i22 to i whatever a list of amounts.
What I would like to do please is find the minimum amount in column i
and for the formula to return the figure from column B.

Thanks in advance,
Paul

 

[Bob Phillips]

Try

=INDEX(B:B,MATCH(MIN(I:I),I:I,0))

 

[paul_black27]

Try

=INDEX(B:B,MATCH(MIN(I:I),I:I,0))

--
__________________________________
HTH

Bob








- Show quoted text -

Hi Bob,

Brilliant, works like a dream.

Thanks,
Paul