Hello Peo,

This worked like a charm. Thanks so much. Now it's my turn to answer some
questions on the site. I always try to "give back" if I can...

Karen


"Peo Sjoblom" wrote:

Try this

=INDEX($F$20:$F$25,MATCH(SMALL($H$20:$H$25,COUNTIF ($H$20:$H$25,"<=0")),$H$20:$H$25,0))



--
Regards,

Peo Sjoblom

(No private emails please)


"K. Westerman" wrote in message
...
I'm still having the problem I mention below. I'm getting, in some
instances, the next lesser matching item when I want the one that is zero.
Can you please help me? If there's a more complicated way, I'm willing to
tackle it if you are.

Thanks so much.

"K. Westerman" wrote:

Hi Ron,

I'm back. In some instances, there is a result of "0", but the formula
is
picking up the next lesser matching item, which is less than zero. I'd
like
it to pick the one that is closest to, but not larger than zero. Is it
possible to tweak this? If I understood the -1, +1, 1, I could take a
crack
at it...

Thanks so much. Here's the example.

Col y Col z Col aa
1000.00% 999999 999999
5.63% 0.250 0.375
5.75% -0.125 0.000
5.88% -0.375 -0.250
6.00% -0.750 -0.625
6.13% -1.000 -0.875
6.25% -1.250 -1.125
6.38% -1.500 -1.375
6.50% -1.750 -1.625

=INDEX(Y32:Y40,MATCH(0,AA32:AA40,-1)+1,1) with a result of 5.88%.

Thanks,

Karen