Solved: Conditional drop-down lists

[BonnieG]

I have a column on my worksheet for shirt size for male and another column for shirt size for female. I have a drop-down list in each cell of the "male" column and a separate drop down list for each cell in the "female" column. Is there any way to keep them from selecting an item from the drop down lists in both columns? For example, if XL is chosen in A4, can I block B4, etc.?

[Bob Phillips]

I am assuming that you have a list of sizes, let's say the men's is in M1:M5, and the DV points at that list.

In the A4 DV, change the formula to

=IF(B4="",M1:M5)

and so on.

[BonnieG]

PERFECT!! I didn't know you could put an "IF" statement in DV.
Thank you so much!!!