Thanks so much for your reply. Some work and some don't. Here's an example
of one that doesn't work:

Col f Col g Col h
RATE 15 DAY 30 DAY
6.250% -0.500 -0.375
6.375% -0.875 -0.750
6.500% -1.125 -1.000
6.625% -1.375 -1.250
6.750% -1.625 -1.500
6.875% -1.750 -1.625

=INDEX($F$20:$F$25,MATCH(0,$H$20:$H$25,-1)+1,1)

This returns #N/A. Have I missed something here?

Also, I would love to know how the formula breaks down; I don't completely
understand the reason you do INDEX and then MATCH and what the -1, and +1,1
mean.

Karen