=INDEX(P2:P58,MATCH(1,(H7=O2:O58)*(L1=N2:N58),0))

OK, there are two colums of data that are required to generate the
correct response.

To make it easier lets say A1 is a drop down with 5 entries all text
Promo.Kit, NRO.Kit, ect.
In B1 there is second drop list, that is dependet on the first.
In this drop down there are a serious of sizes that cororlate with the type
of
promo kit. ie. 11x8, 8.5x11 ect.
With these two entiers I need to fill in C1 and then D1, with additional sizes
that correlate with A1 and B2. The are agian like 11x by 8.5 ect..

The array would then be.
e1 f1 g1 h1
Kit type Trim Size Bleed live Area
Promo 5x7 5.25x7 4.5x10
NRO 5x7 and so on
so basically the index match formula nees to produce a
bleed size and live area based on the kit type and trim
Please advise

See http://www.contextures.com/xlFunctio...ml#IndexMatch4 for a solution...



" wrote:

=INDEX(P2:P58,MATCH(1,(H7=O2:O58)*(L1=N2:N58),0))

OK, there are two colums of data that are required to generate the
correct response.

To make it easier lets say A1 is a drop down with 5 entries all text
Promo.Kit, NRO.Kit, ect.
In B1 there is second drop list, that is dependet on the first.
In this drop down there are a serious of sizes that cororlate with the type
of
promo kit. ie. 11x8, 8.5x11 ect.
With these two entiers I need to fill in C1 and then D1, with additional sizes
that correlate with A1 and B2. The are agian like 11x by 8.5 ect..

The array would then be.
e1 f1 g1 h1
Kit type Trim Size Bleed live Area
Promo 5x7 5.25x7 4.5x10
NRO 5x7 and so on
so basically the index match formula nees to produce a
bleed size and live area based on the kit type and trim
Please advise