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.