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