Hi Domenic,

Thank you for all your time and patience. Thank you once again for a solution
- a Great Formula!

Cheers,
Sam

Domenic wrote:
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(SubRan ge<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!

Hi Domenic,

[quoted text clipped - 6 lines]
Cheers,
Sam

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