Using multiple if functions with data validation
Closed
chriswiec
Posts
2
Registration date
Friday November 16, 2012
Status
Member
Last seen
November 16, 2012
-
Nov 16, 2012 at 01:42 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 21, 2012 at 06:54 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 21, 2012 at 06:54 AM
Hello,
Im trying to create a pull down menu with data validation, however for example if M4 = VT-901 then I want to be able to select a size 1080,7628,2113, but the sizes change depending on whats selected in m4. Right now I have the pull down menus with data validation but it is only for one material I have 3 Materials all with 7 Different sizes. The selection is also in a table on a different sheet. Any help would be greatly appreciated!!!
Im trying to create a pull down menu with data validation, however for example if M4 = VT-901 then I want to be able to select a size 1080,7628,2113, but the sizes change depending on whats selected in m4. Right now I have the pull down menus with data validation but it is only for one material I have 3 Materials all with 7 Different sizes. The selection is also in a table on a different sheet. Any help would be greatly appreciated!!!
5 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 16, 2012 at 09:09 AM
Nov 16, 2012 at 09:09 AM
Hi chriswiec,
This type of Drop Down list is called as Dynamic Drop Down list. To create this check the link mentioned below:
https://www.youtube.com/watch?v=0Ey8-ILjjYs
Do reply if this helps.
This type of Drop Down list is called as Dynamic Drop Down list. To create this check the link mentioned below:
https://www.youtube.com/watch?v=0Ey8-ILjjYs
Do reply if this helps.