openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wade Smart <wadesm...@gmail.com>
Subject [OO] VLookup question with multiple columns
Date Thu, 20 Feb 2014 00:23:17 GMT
=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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message