Don't follow what you're trying to accomplish.

Can't you make a simple datalist?
Names in Column A, ID number in adjacent row in Column B.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Arnie" wrote in message
bel.net...
Hi,

Here's what i'm trying to do:
I have abouth 50 players manualy divided over several teams. Each team has
1-4 players. I want to give each player a unique identifier within the
teams. So player John in team 5 which consist 4 teammembers has id 5_1,
Pete
in the same team has id 5_2

I tried it with index, but the formula gives the value not te index of the
selection.

Any ideas?