Thread: Match 3 Criteria and Return Lowest Numeric Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com
 
Posts: n/a
Default Match 3 Criteria and Return Lowest Numeric Value
Hi Domenic,

Thanks for additional input - much appreciated.

Cheers
Sam

Domenic wrote:
Try...
=INDEX(E5:AC5,MATCH(MIN(IF(E6:AC6=8,E4:AC4)),IF(E 6:AC6=8,E4:AC4),0))
...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Hi All,

[quoted text clipped - 32 lines]
Thanks
Sam

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote