Assuming that J13 and J14 contain the formulas returning the maximum and
minimum values, try...

=INDEX(G17:G24,MATCH(J13,H17:H24,0))

and

=INDEX(G17:G24,MATCH(J14,H17:H24,0))

Note that the formula will only return the first occurrence. Post back
if there can be more than one occurrence of maximum and minimum values.

Hope this helps!

In article <65d6f0b6cd71d@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Your solution works great.

Is it possible to also have a Formula that will return the respective Numeric
Label for each of the minimum and maximum values. The Numeric Label is
housed adjacent to each Numeric Value. Numeric Label in column "G", Numeric
Value in column "H".

Cheers,
Sam

Domenic wrote:
Maybe...

=MAX(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H 13,ID,0),0),0)),H17:H24))

and

=MIN(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H 13,ID,0),0),0)),H17:H24))

Note that both formulas need to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER.

Hope this helps!

Hi Biff,

[quoted text clipped - 13 lines]
Cheers,
Sam