wrote in message
ups.com...
On Sep 21, 11:44 pm, "T. Valko" wrote:
wrote in message
Is there a standard Excel function or standard Excel add-in that
returns the position of the largest value less than or equal to the
lookup value when the lookup array is sorted in descending order?

Try this array formula** :
=MATCH(MAX(IF(A1:A10<=C1,A1:A10)),A1:A10,0)

Perfect! Thanks.


You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP