I have a need to change the list dependent upon the value in another cell.
For example, if the value in cell B2 is "shirts", the list in the next cell needs to be sizes M,L,XL. If the value in cell B2 is " shoes" the list in the next cell needs to be sizes 6,7,8,9,10.
Is this possible?
Any help would be much appreciated.
For example, if the value in cell B2 is "shirts", the list in the next cell needs to be sizes M,L,XL. If the value in cell B2 is " shoes" the list in the next cell needs to be sizes 6,7,8,9,10.
Is this possible?
Any help would be much appreciated.