I got the names to be removed from the dropdown list. I am still
puzzling over the formula in column b.

On Mar 25, 12:12*am, Anthony wrote:
Players(a1) * Available(b1) * * * * * * * Pick 1 Pick 2 * Pick 3 * *Pick 4....Pick 8
player1(a2) * *player1(b2) * Team1 * * (e2)
player2 * * * * player2 * * * * * Team2
player3 * * * * player3 Team3
player4 * * * * player4 * * * * * Team4
player5 * * * * player5 * * * * * Team5
player6 * * * * player6 Team6 (m7)
player7 * * * * player7
.........
player54 * * * player54

I have tried to simulate this as best I can above. *Just an FYI, I am
trying to create a roster maker for a youth flag football league.
Once I pick a name from the dropdown boxes in cell range e2:m7, i want
the cell holding the equivalent value in the available column to go
blank. *If possible, I would like the value in the dropdown box to be
removed as well. *This would simply be as a double measure to ensure
the same kid was not placed on two teams. *I hope this helps and I
hope you can help me. *Thanks.

On Mar 24, 11:33*pm, "T. Valko" wrote:



=if(isna(match($a2,$e$2:$m$7,0)),$a2," ")

The lookup_array has to be a one dimensional array. You're attempting to use
a two dimensional array.

I can't follow the description of your setup so I don't know what you're
trying to do.

--
Biff
Microsoft Excel MVP

"Anthony" wrote in message

....

The following formula will not work and for the life of me I can not
figure out why:
=if(isna(match($a2,$e$2:$m$7,0)),$a2," ")
In cell a1 is the text "All Players". *From cells a2-a55, I have the
following data: player1, player2, player3...player54. *In cell b1 is
the text "Available players". *From cells b2-b55, I have the above
formula so the default values are the same values as column a. *From
cells d2-d7 is the text team 1, team 2...team 6. *The values in cell
range e2:m7 will be populated by a dropdown box which includes all the
data from cells a2:a55. *When I pick a name from the dropdown box in
any cell in the e2:m7 range, the corresponding value in column b
should be removed and replaced by a blank space. *At least that is how
I think the above formula should work but it doesn't do anything. *Can
someone help me with this? *Thanks.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -