I got it close but it always looks for the lowest number which I need it to
look for the lowest number that has an "x" in that row:
=INDEX(A1:A100,MATCH(MIN(E1:E100)&"x",E1:E100&D1:D 100,0))

"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