Match 3 Criteria and Return Lowest Numeric Value
Domenic's formula catches that
=INDEX(E5:AC5,MATCH(MIN(IF(E6:AC6=F1,E4:AC4)),IF(E 6:AC6=F1,E4:AC4),0))
again array entered
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Herbert Seidenberg" wrote in message
oups.com...
If you copied the data from this site,
you will get unusual spaces (Alt 0160) in your data.
Try typing in the data manually.
If Steve or Bob have not replied in 2 hours,
I will post my formula.
|