Hi Domenic,

Thank you so very much for all your assistance and perseverance.

Your Formula has done the job Brilliantly!

Sorry it took me so many attempts to explain.

Cheers,
Sam

Domenic wrote:
Assumptions:

F10:FV10 contains the Numeric Labels

F11:V11 contains the Numeric Values

X11 contains the criteria

Formulas:

First, define the following names...

Select Y11

Insert Define Name

Name: NLabels

Refers to: =Sheet1!$F$10:$V$10

Click Add

Name: NNV

Refers to: =INDEX(NValues,Pos)+1

Click Add

Name: NValues

Refers to: =Sheet1!$F11:$V11

Click Add

Name: Pos

Refers to: =MATCH(Sheet1!$X11,NLabels,0)

Click Add

Name: SubRange

Refers to:

=INDEX(NLabels,MATCH(NNV,NValues,0)):INDEX(NLabel s,MATCH(2,1/(NValues=NNV
)))

Click Ok

*Change the sheet reference accordingly.

Then, enter the following formula in Y11, and copy down if necessary...

=IF(ISNUMBER(MATCH(NNV,NValues,0)),(MAX(IF(SubRan ge<$X11,COLUMN(SubRange)
-MIN(COLUMN(SubRange))+1))+1)+(MATCH(NNV,NValues,0)-1),MATCH($X11,NLabels
,0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Extraction of previous Data Sample:

[quoted text clipped - 64 lines]
Cheers,
Sam

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