Using a number to generate a name

[Bruce at Pubdarts]

Hi,
i run various darts events & each week we do a random draw to assign a number of players to a board, the up coming event has a lot of longer or more difficult names to spell & during the draw there isn't much time for me to type them in.
we have 60 players & those registered keep their registration number for the length of the event, the registration list is on a different tab to the game tab but are on the same excel sheet so my question is..
can i link the pages so when i type any number 1to 60 in column A the name will appear in column B as per the list in the other tab?

been trying Vlookup & Xlookup but i cant seent to get it to work.. any help would be much appreciated.

Bruce
p.s. can upload an image but sheet 1 has numbers 1 to 60 in column A & a list of names against those numbers in column B what i need is to type the drawn number in column a sheet 2 & the respective name to appear in column B on sheet 2.

 

[StephenCrump]

Welcome to the Forum!

VLOOKUP and XLOOKUP (if you have moved up from Excel 2013 and it's available?) should both work:

Book3
	A	B	C
1	Player #	VLOOKUP	XLOOKUP
2	3	C	C
3	7	G	G
Sheet2

Cell Formulas
Range	Formula
B2:B3	B2	=VLOOKUP(A2,Sheet1!A$2:B$11,2,)
C2:C3	C2	=XLOOKUP(A2,Sheet1!A$2:A$11,Sheet1!B$2:B$11)

	A	B
1	No	Name
2	1	A
3	2	B
4	3	C
5	4	D
6	5	E
7	6	F
8	7	G
9	8	H
10	9	I
11	10	J
Sheet1

(In both cases, I have used an exact match on player number, rather than relying on the player numbers being all there and sorted correctly.

 

[Bruce at Pubdarts]

Welcome to the Forum!

VLOOKUP and XLOOKUP (if you have moved up from Excel 2013 and it's available?) should both work:

Book3
	A	B	C
1	Player #	VLOOKUP	XLOOKUP
2	3	C	C
3	7	G	G
Sheet2

Cell Formulas
Range	Formula
B2:B3	B2	=VLOOKUP(A2,Sheet1!A$2:B$11,2,)
C2:C3	C2	=XLOOKUP(A2,Sheet1!A$2:A$11,Sheet1!B$2:B$11)

	A	B
1	No	Name
2	1	A
3	2	B
4	3	C
5	4	D
6	5	E
7	6	F
8	7	G
9	8	H
10	9	I
11	10	J
Sheet1

(In both cases, I have used an exact match on player number, rather than relying on the player numbers being all there and sorted correctly.

Thank you for your reply, I shall give it a go today to see if I can make it work, the players numbers are always in order but the players names are not alphabetical this is why I was going with the number changing to a name, will update if I'm successful using your method
Bruce

 

[Bruce at Pubdarts]

Welcome to the Forum!

VLOOKUP and XLOOKUP (if you have moved up from Excel 2013 and it's available?) should both work:

Book3
	A	B	C
1	Player #	VLOOKUP	XLOOKUP
2	3	C	C
3	7	G	G
Sheet2

Cell Formulas
Range	Formula
B2:B3	B2	=VLOOKUP(A2,Sheet1!A$2:B$11,2,)
C2:C3	C2	=XLOOKUP(A2,Sheet1!A$2:A$11,Sheet1!B$2:B$11)

	A	B
1	No	Name
2	1	A
3	2	B
4	3	C
5	4	D
6	5	E
7	6	F
8	7	G
9	8	H
10	9	I
11	10	J
Sheet1

(In both cases, I have used an exact match on player number, rather than relying on the player numbers being all there and sorted correctly.

i had a few teething problems on game sheet 2, 4, 6 & 8 where players 5 & 6 failed to populate but as soon as i locked the rule in all sections started to work perfect. thank you for the assistance & when i'm ready to add another technical specification such as the draw sheets automatically updating the tables I'll be in touch lol... not sure its possible as they will shuffle up and down as players earn points along the event but much appreciated

 

[StephenCrump]

Great, I'm glad we could help.