Assuming that the Numerical Labels are unique, and that X11 contains the
criterion, try the following...

1) Change the reference for the defined name 'Pos' to...

=MATCH(Sheet1!$X$11,NLabels,0)

For some reason you had Sheet!$X$10 as your cell reference in the sample
file you sent me.

2) Use the following formula for Y11...

=IF(ISNUMBER(MATCH(NNV,NValues,0)),(MAX(IF(SubRang e<X11,COLUMN(SubRange)-
MIN(COLUMN(SubRange))+1))+1)+(MATCH(NNV,NValues,0)-1),MAX(IF(NValuesNNV,
COLUMN(NValues)-MIN(COLUMN(NValues))+1)+1))

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

Hope this helps!

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

Hi Domenic,

Replace the Numeric Label 5 with Numeric Label 14, and replace Numeric
Label 12 with Numeric Label 5. If the criteria/Numeric Label is 5, is
Column 7 your expected result?

Yes

Cheers,
Sam