Here is the problem.

Product XX - can either be fixed or flexible - and can be approved or not
approved

I have the dynamic dropdown working matching for either

Product XX to the fixed or flexible
or
Product XX to the approved or not approved

is there a good way to only show Product XX (either fixed or flexible) when
it is approved.

Don't know if this is the right way to go - comments would be appreciated

=if((and(C4=""),(C8="")),product2,
if(C8<"",offset(indirect(C8),0,0,counta(indirect( C8&"COL")),1),
C4<"",offset(indirect(C4),0,0,counta(indirect(C4& "COL")),1))

Is this anywhere close??

Where C8 has the state dropdown information
C4 has the fixed flexible dropdown information.



"Brad" wrote:

Here is the problem.

Product XX - can either be fixed or flexible - and can be approved or not
approved

I have the dynamic dropdown working matching for either

Product XX to the fixed or flexible
or
Product XX to the approved or not approved

is there a good way to only show Product XX (either fixed or flexible) when
it is approved.

Still working on this - this is the equation I have up-to this point
=IF((AND(C4="",C8="")),product2,IF(C8<"",OFFSET(I NDIRECT(C8),0,0,COUNTA(INDIRECT(C8&"COL")),1),OFFS ET(INDIRECT(C4),0,0,COUNTA(INDIRECT(C4&"COL")),1)) )

Again where C4 = fixed vs. flexible
and C8 = has state information


"Brad" wrote:

Here is the problem.

Product XX - can either be fixed or flexible - and can be approved or not
approved

I have the dynamic dropdown working matching for either

Product XX to the fixed or flexible
or
Product XX to the approved or not approved

is there a good way to only show Product XX (either fixed or flexible) when
it is approved.