Hi Jason,
it depends on if the OP really wants the next larger value even if it is an
exact match, I wasn't sure about that
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Jason Morin" wrote in message
...
Hi Peo. I think you mean <= , not < .
Jason
-----Original Message-----
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?
.
|