• 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
 
Faster could help you, that you set your example and let us see how you started to solve the problem.
Here are two examples if I can help.
With Regards
 

Attachments

  • hrayani-navic42054-1.xlsb
    95.3 KB · Views: 4
  • hrayani-navic42054-2.xlsb
    106 KB · Views: 4
Back
Top