In that case, change the formula for W11 to the following...

=IF(U111,MATCH(TRUE,INDEX(NValues2=V11,0),0),#N/A)

or

=IF(U111,MATCH(TRUE,NValues2=V11,0),#N/A)

....confirmed with CONTROL+SHIFT+ENTER.

In article <5a5057d4c76ec@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

I'll try to clarify.

Your original Formula provided the correct answer based on SEARCH/ sort type
Ascending For Numeric Label and Ascending for Numeric Value. However, I
require the Formula to use SEARCH/ sort type Ascending for Numeric Label and
Descending for Numeric Value. That is the only change or difference to the
original Formula you provided.

Cheers,
Sam