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.

This will return the corresponding value in Row 11, and add 1.

W11:

=IF(U111,LOOKUP(2,1/(F11:INDEX(F11:R11,U11-1)=V11),COLUMN(F11:INDEX(F11:R11,U11-1))-COLUMN(F11)+1)+1,#N/A)

Cheers,
Sam

Domenic wrote:
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.

Hi Domenic,

[quoted text clipped - 8 lines]
Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200601/1