Thanks for the help. I just realized what you meant by two
dimensional. I rearranged the data and the formula works.

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 -