Hi Domenic,

Thank you so much - Great!

Cheers,
Sam

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

Hi Domenic,

[quoted text clipped - 9 lines]
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.

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