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 -