Apologies for being a noob.
I need some help with changing a dropdown list based on input(s) from other cells.
I have 4 columns: A, B, C, and Size
A, B, and C are dropdown lists using Data Validation and can be Y, N, or blank
Size is a dropdown list using Data Validation and can be XS, S, M, L, XL, blank
I want the Size dropdown to change based on Y's in A, B, and C
So if A, B, or C = 'Y' the Size list no longer shows XS and only has S, M, L, XL, blank
If two of the 3, A and B or B and C or A and C = 'Y' the Size list no longer shows XS or S and is only M, L, XL, blank
And if all 3 = 'Y' the Size list no longer shows XS, S, M and only shows L, XL, blank
I've tried a bunch of variations of IF(OR) and IF(AND) but can't seem to make it work fully.
Any help would be huge.
Thanks
Bookmarks