Reply to thread

Message: [QUOTE="locke1990, post: 3266430"] I am creating a formation sheet for soccer. I have 11 positions from which they are pulling a name from a drop down menu from another workbook. I also have a roster list on the page with the formation. What I want to do is make it so that when I use a name from a drop down menu, it is "removed" from the roster list, but if i change the name in the formation by using a different player, the original name goes back into the roster list. the easiest way i can think of to do this would be an IF statement in the roster part, but i don't know how to make it search for a name in the formation part. I have the formation part defined as name _352, so i am trying to search for "player 1" in "_352". If the name is used, then it would be blank in the roster list. I was thinking something like =IF((search(_352, player1)), "", player1)) but this doesn't work. Any Help would be great. Thanks. [/QUOTE]