Find Minimum and Return a Figure
Try
=INDEX(B:B,MATCH(MIN(I:I),I:I,0))
--
__________________________________
HTH
Bob
"Paul Black" wrote in message
...
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
|