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

Related:

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