View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Indirect function ?

Hi Carlos,

Does this work?

=INDEX(B2:B6,MATCH(MIN(F2:F6),F2:F6,0))

Ken Johnson