J
jtfalk
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)*(D1100="x"),0)
The problem is it looks at the zero and returns second
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)*(D1100="x"),0)
The problem is it looks at the zero and returns second