• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation Dependent List

hrayani

New Member
Hello All,

I am posting first time on this site.

Need help with Data Validation

Here is a sample data
Row 1 > Heading
Row 2 > Data

Total 3 Named Ranges
ref (a2:a10)
articlename (b2:b10)
size (c2:c10)

REF # - ARTICLE NAME - SIZE
414 .....DUVET ..............135 X 200 CM
414 .....DUVET................140 X 200 CM
414 .....DUVET ...............150 X 200 CM
414 .....DUVET ................160 X 200 CM
414...... PILLOW ...............70 X 80 CM
414 ......PILLOW ...............80 X 80 CM
414.......PILLOW ...............90 X 80 CM
414 ......PILLOW ...............100 X 80 CM
414 ......PILLOW ................60 X 40 CM


Now in Sheet 2
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.

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 values of cell A2 & B2

Any help would be appreciated.
Regards,
Humayun
 
Top