View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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