One way

=INDEX(A1:A10,MATCH(SMALL(A1:A10,COUNTIF(A1:A10,"< "&C1)+1),A1:A10,0))

where A1:A10 is the lookup range and C1 the lookup value

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"bp" wrote in message
...
How do I find next largest value that is greater than lookup_value using
the
lookup function or any other functions?