Hello,
I have been tirelessly working on trying to make a simple program on Excel. I have a list of people in column A, inputted as a text. On the same worksheet I have a drop down list with the same names available for selection. Drop down lists are C10, C11, C21 and C22. I would like the names in column A to disappear when they are selected from any drop down list. I have included a picture to better articulate my problem.
I managed some semblance of success by entering the following formula in to A6: =IF(C10="Allen", " ", "Allen"). This only works if Allen's name is chosen from the drop down list at C10, but not other drop down lists. Can anybody offer some advice on this problem?
Excel_Pic2.jpg
Bookmarks