Data Validation Dependent Drop Down 2 Criteria

[hrayani]

Hello Friends,

I am using the below formula in data validation to get the dependent drop down list

=OFFSET('SIZE ORDER'!$B$1,MATCH(A2,so_ref_no,0),0,COUNTIF(so_ref_no,A2),1)

I just want to add another criteria Match(C2,so_size

Please if anyone can add the 2nd criteria in the above formula

Regards,

Humayun

 

[hrayani]

Hello Friends,

Any Solution ????

 

[hrayani]

With lot of experiments I have come up with this formula

=OFFSET('SIZE ORDER'!$C$1,MATCH(1,(A2=so_ref_no)*(C2=so_article_name),0),0,COUNTIF(so_article_name,C2),1)

This seems to work fine. But when I reopen the file - the cell gets freeze. it does not allow the drop down list ???


Any help would be appreciated....

 

[hrayani]

Hello friends,

still waiting for for someone to solve this for me

 

[hrayani]

Formula in POST # 3 does not seem to work fine....

Here is a sample data

[FONT=&quot]Row 1 > Heading[/FONT]
[FONT=&quot]Row 2 > Data

[/FONT]
[FONT=&quot]Total 3 Named Ranges
ref (a2:a10)
articlename (b2:b10)
size (c2:c10)[/FONT]

[FONT=&quot]REF # ARTICLE NAME SIZE[/FONT]
[FONT=&quot]414 DUVET 135 X 200 CM[/FONT]
[FONT=&quot]414 DUVET 140 X 200 CM[/FONT]
[FONT=&quot]414 DUVET 150 X 200 CM[/FONT]
[FONT=&quot]414 DUVET 160 X 200 CM[/FONT]
[FONT=&quot]414 PILLOW 70 X 80 CM[/FONT]
[FONT=&quot]414 PILLOW 80 X 80 CM[/FONT]
[FONT=&quot]414 PILLOW 90 X 80 CM[/FONT]
[FONT=&quot]414 PILLOW 100 X 80 CM[/FONT]
[FONT=&quot]414 PILLOW 60 X 40 CM[/FONT]
[FONT=&quot]
[/FONT]

[FONT=&quot]
Now in Sheet 2[/FONT]
[FONT=&quot]When I enter 414 in cell A2 a drop list appears in cell B2 showing article names
here is the formula

=OFFSET(Sheet1!$B$1,MATCH(A2,ref,0),0,COUNTIF(ref,A2),1)

Its working fine & I am able to select a value from the list.

[/FONT]
[FONT=&quot]Now all I want is another formula for cell C2 (in data validation) which shall give a drop down list which would be dependent on entries of cell A2 & B2[/FONT]
[FONT=&quot]
Any help would be appreciated.

Regards,

Humayun[/FONT]

 

[hrayani]

Hey friends,

no replies not even one