Solved: Index / Match NA

[gimli]

Hey all,

Having trouble with an index match...returning N/A sometimes but not others...

Im trying to pull the min value from column K in the dont work example Just the first min value...
depending on the data it works ok some times..but not others. I also have and example when it works.

see attached...any ideas?

thanks much

[gimli]

hrmmm

[p45cal]

You need to move a closing parenthesis in the one that doesn't work:
=INDEX(E4:E21,MATCH(INDEX(K4:K21,MATCH(MIN(K4:K21),K4:K21),0),K4:K21,0))
to:
=INDEX(E4:E21,MATCH(INDEX(K4:K21,MATCH(MIN(K4:K21),K4:K21,0)),K4:K21,0))

but it seems convoluted; doesn't:
=INDEX(E4:E21,MATCH(MIN(K4:K21),K4:K21,0))
give the same result?

[gimli]

Bah! Thanks..yes...my thinking was a bit twisted

this works just fine

=INDEX(E4:E21,MATCH(MIN(K4:K21),K4:K21,0))
thanks much