Filter or Index function to match and bring the values

[ChetanPuri]

Good Morning Excel Gurus,
I have an excel question, I have the below value in sheet 1 and on Sheet 2 I want to match the values of column A and then want to build the formula in sheet 2 to those values in B to F from sheet1, just wondering is there a formula which can do all at the same time

2024-10 Detail_report.xlsm
	A	B	C	D	E	F
1	Service Number	GL	WKID	Job	Cost Centre	Cost Type
2	N0017299R	52829710	52
3	N8713661R	40929710	40
4	N0017295R	40949710	40
5	N0016175R	40939710	40
GL Codes

Book2
	A	B	C	D	E	F
1	Service Number	GL	WKID	Job	Cost Centre	Cost Type
2	N0017299R		52
3	N8713661R	No Results	40
4	N0017295R	No Results	40
5	N0016175R	No Results	40
Sheet1

 

[bebo021999]

VLOOKUP can help.
FOR EX IN B2:

=IFERROR(VLOOKUP($A2,'GL codes'!$A$2:$F$5,COLUMNS($A:B),0),"")

Wrag down and accross