Look up to return name

[zone709]

Trying to return name in sheet1 from sheet2. If Id number in sheet1 in D matches Id number in sheet 2 in A. Return the name in B in sheet2 to sheet1 column C yellow.

Book1
	A	B	C	D
1	#	name	Return here	ID
2	1	joe		10
3	2	ralph		56
4	3	jake		45
5	4	mike		23
6	5	frank		10
7	6	mario		45
Sheet1

Book1
	A	B
1
2	10	Bite
3	23	Rock
4	56	Bite
5	45	Rock
6
Sheet2

 

[Peter_SSs]

Is this what you mean?

zone709.xlsm
	A	B	C	D
1	#	name	Return here	ID
2	1	joe	Bite	10
3	2	ralph	Bite	56
4	3	jake	Rock	45
5	4	mike	Rock	23
6	5	frank	Bite	10
7	6	mario	Rock	45
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=XLOOKUP(D2:D7,Sheet2!A2:A5,Sheet2!B2:B5,"not found",0)
Dynamic array formulas.

 

[zone709]

When i put the formula on anther sheet i get #Spill. Do you know why i might get that?

 

[zone709]

Got it works thanks. Figured it out

 

[Peter_SSs]

Got it works thanks.

You're welcome. Thanks for the confirmation.