=VLOOKUP($E18,$Teams.$A$12:$I$23,($G$10+1),0) E18 = Player Number on Roster (1 to 12) Teams.A12:I23 = Team Roster names G10+1= the input of team number
When this was setup we werent concerned with player jersey numbers but since that time, we have had to add them to all our forms. What I would like to is add in another column in the Teams with the jersey number. So we have Teams A 12 to 23 1 2 3 etc Teams B player name player name etc Teams C player name etc and I want to do this: Teams A, B, C, D, E 1, 14, name, 2, name 2, 4, name, 5, name etc. Can anyone help with this? My other non preferable option is do add another range under the teams for jersey numbers. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 ------------------------------------------- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
