openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wade Smart <>
Subject [OO] VLookup question with multiple columns
Date Thu, 20 Feb 2014 00:23:17 GMT

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
3 etc

Teams B
player name
player name

Teams C
player name

and I want to do this:
Teams A, B, C, D, E
1, 14, name, 2, name
2, 4, name, 5, name

Can anyone help with this?

My other non preferable option is do add another range under
the teams for jersey numbers.


Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

List Conduct Guidelines:
To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message