Okay, I think I see the problem, I forgot the +1 bit...

The original notation...

=IF(U111,MATCH(TRUE,F11:INDEX(F11:R11,U11-1)=V11,0)+1,#N/A)

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

The named ranges...

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

or

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

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

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

Hi Domenic,

I'm not getting the expected Results. I may have done something incorrectly
with the Named Ranges but I don't think so.

If it is not too much to ask, could you re-produce your original A1notation
cell referenced Formula below with the changes you've just made based on the
SEARCH/ sort type for Numeric Labels being Ascending and Numeric Values
Descending.