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.