PDA

View Full Version : Solved: Index / Match NA



gimli
05-19-2010, 11:18 AM
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
05-20-2010, 04:23 AM
hrmmm

p45cal
05-20-2010, 05:00 AM
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
05-20-2010, 05:54 AM
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