Hi,

Try this ARRAY formula

=INDEX(A1:A5,MATCH(1,("x"=D1:D5)*(MIN(IF(E1:E50,E 1:E5))=E1:E5),0))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"jtfalk" wrote:

A B C D E
First x 5
second x 0
third x 2
fourth x 2
fifth x
1

I am trying to get the A name with criteria of D and the lowest number. This
list is about 100 items. So in the above case is would look through all of D
for x's and the lowest E value which is 1 above. I was trying this:
=INDEX(A1:A100,MATCH(MIN(E1:E100),G2:G19,0)*(D1:D1 00="x"),0)
The problem is it looks at the zero and returns second