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