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
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