Fill in data base on entry

[JTL9161]

I am trying to find a formula that will fill in a number based on where a name is entered. As a name is entered, I need the number where the name is entered to fill in on a table.

Thanks,
James

Book1
	A	B	C	D	E	F	G	H
1
2		User enters names here
3	1	DAVE	BILL
4	1	BOB	GREG
5	2	TOM	TIM
6	2	STEVE	BRIAN
7	3	GEORGE	BRYAN
8	3	MIKE	DOUG
9	4	STU	ED
10	4	RICK	TONY
11
12				Need coorsponding number to fill in below
13			BILL	1
14			BOB	1
15			BRIAN	2
16			BRYAN	3
17			DAVE	1
18			DOUG	3
19			ED	4
20			GEORGE	3
21			GREG	1
22			MIKE	3
23			RICK	4
24			STEVE	2
25			STU	4
26			TIM	2
27			TOM	2
28			TONY	4
29
Sheet1

 

[etaf]

=IFERROR(INDEX($A$3:$A$10,MATCH(C13,$B$3:$B$10,0)),INDEX($A$3:$A$10,MATCH(C13,$C$3:$C$10,0)))

probably be able to use some of the 365 functions

Book2
	A	B	C	D
1
2		User enters names here
3	1	DAVE	BILL
4	1	BOB	GREG
5	2	TOM	TIM
6	2	STEVE	BRIAN
7	3	GEORGE	BRYAN
8	3	MIKE	DOUG
9	4	STU	ED
10	4	RICK	TONY
11
12				Need coorsponding number to fill in below
13			BILL	1
14			BOB	1
15			BRIAN	2
16			BRYAN	3
17			DAVE	1
18			DOUG	3
19			ED	4
20			GEORGE	3
21			GREG	1
22			MIKE	3
23			RICK	4
24			STEVE	2
25			STU	4
26			TIM	2
27			TOM	2
28			TONY	4
Sheet1

Cell Formulas
Range	Formula
D13:D28	D13	=IFERROR(INDEX($A$3:$A$10,MATCH(C13,$B$3:$B$10,0)),INDEX($A$3:$A$10,MATCH(C13,$C$3:$C$10,0)))

 

[Kaper]

Are your names in C13 and down written manually? seems that yes. then in D13 and copy down try:

=XLOOKUP(C13,B$3:B$12,A$3:A$12,XLOOKUP(C13,C$3:C$12,A$3:A$12,"no such value",0),0)

Edit: somehow I did'nt see solution by Wayne.
It is basically the same, but using new functions.
To be exactly equivalent (no special treatment for non-existing names) will be shorter:

=XLOOKUP(C13,B$3:B$12,A$3:A$12,XLOOKUP(C13,C$3:C$12,A$3:A$12,,0),0)

 

[JTL9161]

Thanks. I give it a try.