Match and return different value if match found

[Adamd325]

I will try to make sense;
I am trying to find number matches in two batches of data on two separate sheets. Once a match is found i need the return data to be from a cell adjacent to the cell in which the match is found on sheet 2 specifically pulling a date value across to the master sheet.
Can anyone help?

 

[JamesCanale]

this?

MrExcelPlayground23.xlsx
	A	B	C	D	E	F	G	H
1	Thing			Sheet 1			Sheet 2
2	Fred	1/5/2024		Thing	Date		Thing	Date
3				John	5/28/2024		Harold	1/2/2024
4				Fred	4/25/2024		Jamie	1/3/2024
5				Mary	3/25/2024		Mary	1/4/2024
6				Sally	2/15/2024		Fred	1/5/2024
7				Jamie	1/15/2024		Wilhelm	1/6/2024
8							Jack	1/7/2024
9							John	1/8/2024
Sheet5

Cell Formulas
Range	Formula
B2	B2	=IF(ISNUMBER(XMATCH(A2,Table4[Thing],0)),IFERROR(INDEX(Table5[Date],XMATCH(A2,Table5[Thing],0)),""),"")

 

[Adamd325]

Yes exactly that! Thank you!