Create a drop down list if adjacent cell is populated

[AverageJoe]

Windows 7 / Excel 2010

I would like to create a drop-down list based on whether an item in a list has been 'selected' by placing an 'X' in the preceding adjacent cell.

Data:
A B
Apples
X Pears
X Grapes
Lemons

The drop-down list should only include Pears and Grapes.

 

[NeonRedSharpie]

So basically, you're going to need two lists (as I understand it). Lets say your drop down is in cell A1. In column C, you have your list {Apples, Pears, Grapes, Lemons}. In column B you have your marker {,X,X,}. Then, in column D, you have an if statement.

=IF(B1<>"",C1,"")

Your data validation should now be column D.

 

[AverageJoe]

Thank you. This solution works well. Is there a way to remove the empty spaces included in the drop-down list?