having a problem with IF and SEARCH
 

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.

having a problem with IF and SEARCH
 

Maybe

=if(isnumber(search(_352,player1)),"",player1)


locke1990 wrote:

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.

--

Dave Peterson

having a problem with IF and SEARCH
 

Say we want to see if a name is in a list of names. Say A1 thru A30 contains:

James
John
Robert
Michael
William
David
Richard
Charles
Joseph
Thomas
Christopher
Daniel
Paul
Mark
Donald
George
Kenneth
Steven
Edward
Brian
Ronald
Anthony
Kevin
Jason
Matthew
Gary
Timothy
Jose
Larry
Jeffrey

The formula:

=IF(ISNA(MATCH("Malcolm",A1:A30,0)),"name not there","name there")

would tell you that Malcolm is not in the list.
--
Gary''s Student - gsnu200909


"locke1990" wrote:

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.

having a problem with IF and SEARCH
 

this really isn't doing what i need...

"Gary''s Student" wrote:

Say we want to see if a name is in a list of names. Say A1 thru A30 contains:

James
John
Robert
Michael
William
David
Richard
Charles
Joseph
Thomas
Christopher
Daniel
Paul
Mark
Donald
George
Kenneth
Steven
Edward
Brian
Ronald
Anthony
Kevin
Jason
Matthew
Gary
Timothy
Jose
Larry
Jeffrey

The formula:

=IF(ISNA(MATCH("Malcolm",A1:A30,0)),"name not there","name there")

would tell you that Malcolm is not in the list.
--
Gary''s Student - gsnu200909


"locke1990" wrote:

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.