So you want the larger closest value and regardless if a value is negative
so if B5 was -3233 you still want Phd5?

=INDEX(Capacity,MATCH(SMALL(INDEX(Capacity,,1),COU NTIF(INDEX(Capacity,,1),"<"&ABS(B5))+1),INDEX(Capa city,,1),0),2)

--
Regards,

Peo Sjoblom

Portland, Oregon




"DMB" wrote in message
...
No it shoud have been a phd5.