Try the following...

Select U11 first

Insert Name Define

Name: NLabels

Refers to:

=Sheet1!$F$10:$R$10

Click Add

Name: NValues

Refers to:

=Sheet1!$F11:$R11

Click Add

Name: NValues2

Refers to:

=Sheet1!$F11:INDEX(Sheet1!$F11:$R11,Sheet1!$U11-1)

Click Ok

*Change the sheet reference accordingly.

Then use the following formulas...

U11:

=MATCH(T11,NLabels,0)

V11:

=INDEX(NValues,U11)+1

W11:

=IF(U111,LOOKUP(2,1/(NValues2=V11),COLUMN(NValues2)-MIN(COLUMN(NValues2
))+1)+1,#N/A)

X11:

=IF(U111,IF(ISNA(W11),LOOKUP(2,1/(NValues2=T11),COLUMN(NValues)-MIN(COL
UMN(NValues2))+1)+1,W11),#N/A)

Hope this helps!

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

Hi Domenic,

Your Formula has certainly done the job - thank you very much for all your
help.

I tried to adapt your Formula using a Named Range (NLabels) created for the
Numeric Labels - but used with an Offset of ONE Row to point to the Numeric
Values below the Numeric Labels: cell Ranges F11:R11 (per your Formula).
However, I cannot get the INDEX and OFFSET Functions to return the correct
values.

Is it possible for you to re-vamp the Formula below using the Named Range
NLabels with an Offset of "one" for the Row to replace Cell Ranges F11:R11.