Excel formula support

[Babycakes]

HI all

I have two sheets that i keep getting a spill on.  Wanting to bring the cost centre into Sheet 2 based if the item id, end date and invoice number match sheet 1 and 2?

Can you assist?

Sheet 1

ItemID	Cost centre	End date	Invoice Number
01_816_0115_1_1	ABC	1/05/2023	25318
01_814_0115_1_1	ABC	1/05/2023	25318
01_815_0115_1_1	ABC	1/05/2023	25318
01_811_0115_1_1	ABC	1/05/2023	25318
01_812_0115_1_1	ABC	1/05/2023	25318
01_813_0115_1_1	ABC	1/05/2023	25318
01_816_0115_1_1	ABC	8/05/2023	25471
01_814_0115_1_1	ABC	8/05/2023	25471
01_815_0115_1_1	ABC	8/05/2023	25471
01_811_0115_1_1	ABC	8/05/2023	25471
01_812_0115_1_1	ABC	8/05/2023	25471
01_813_0115_1_1	ABC	8/05/2023	25471
01_832_0115_1_1	DEF	1/05/2023	25475
01_806_0115_1_1	DEF	1/05/2023	25475
01_804_0115_1_1	DEF	1/05/2023	25475
01_805_0115_1_1	DEF	1/05/2023	25475
01_801_0115_1_1	DEF	1/05/2023	25475
01_802_0115_1_1	DEF	1/05/2023	25475

Sheet 2

InvoiceNumber	ItemID	End Date	Cost Centre
25523	01_013_0107_1_1_T	20230513
25523	01_013_0107_1_1_T	20230506
25523	01_002_0107_1_1_T	20230512
25523	01_015_0107_1_1_T	20230512
25523	01_014_0107_1_1_T	20230507
25523	01_014_0107_1_1_T	20230514
25523	01_011_0107_1_1_T	20230512
25541	04_170_0136_6_1_T	20230508
25541	04_181_0136_6_1_T	20230511
25541	04_170_0136_6_1_T	20230501
25541	04_181_0136_6_1_T	20230504
25543	04_165_0136_6_1_T	20230502
25543	04_160_0136_6_1_T	20230504
25543	04_165_0136_6_1_T	20230503
25543	04_160_0136_6_1_T	20230511
25543	04_165_0136_6_1_T	20230508
25543	04_165_0136_6_1_T	20230505
25543	04_165_0136_6_1_T	20230510

[Ashish_Mathur]

Shouldn't you be posting your Excel question here - Results in Microsoft 365 and Office - Microsoft Community

[Babycakes]

Thank you -didnt know this existed