View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Match 3 Criteria and Return Lowest Numeric Value

Also, if there's more than one 'Numeric Value' with the lowest value,
the formula will return the first occurrence. If you want to return all
corresponding 'Numeric Labels', the formula would need to be modified.

Hope this helps!

In article ,
Domenic wrote:

Try...

=INDEX(E5:AC5,MATCH(MIN(IF(E6:AC6=8,E4:AC4)),IF(E6 :AC6=8,E4:AC4),0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!