12 Players

[Balcomie]

I have a group of 12 player in column A1 to A12 and have them numbered 1 to 12 in Column B - Looking to play golf in 3 teams of 4 over 6 days. Mixing the Guy's up so they get a chance to play with all the other Team Players (if possible)

I have selected Column D to indicate Day 1 to 6 and Columns E,F,G & H to select the Players.

Here is the snag - On the way to the games each Player will be allocated a Number 1 to 12 which he will keep and by use of a Matrix the Teams will be mixed up accordingly.

So what I am thinking is if I can get a Formula where I can "Say" select Day 1 Players 12, 5, 3 & 1 in the first game I put their allocated number in Cell E1 (12) F1 (5) G1 (3) H1 (1) and their Names appear instead of the number. Is this possible

I would welcome any suggestion

 

[reberryjr]

Based on the layout you said you have, this formula should get what you need.

 =VLOOKUP(E2,$A1:$B4,2,FALSE)

[TABLE="class: grid, width: 320"]
<tbody>[TR]
[TD="width: 64"]Number[/TD]
[TD="width: 64"]12[/TD]
[TD="width: 64"]5[/TD]
[TD="width: 64"]3[/TD]
[TD="width: 64"]1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Tom[/TD]
[TD]Brody[/TD]
[TD]Harry[/TD]
[TD]Steve[/TD]
[/TR]
</tbody>[/TABLE]


HTH

 

[AhoyNC]

You may find this golf pairing tool of help.

http://golfsoftware.com/tools/schedule/golf-pairings-generator.html

 

[Balcomie]

Thank you, looks good

 

[Balcomie]

Thank you - Great link saves a lot of pencil work