Excel formula support

Question

HI all&nbsp;I have two sheets that i keep getting a spill on.&nbsp; Wanting to bring the cost centre into Sheet 2 based if the item id, end date and invoice number match sheet 1 and 2?&nbsp;Can you assist?Sheet 1ItemIDCost centreEnd dateInvoice Number01_816_0115_1_1ABC1/05/20232531801_814_0115_1_1ABC1/05/20232531801_815_0115_1_1ABC1/05/20232531801_811_0115_1_1ABC1/05/20232531801_812_0115_1_1ABC1/05/20232531801_813_0115_1_1ABC1/05/20232531801_816_0115_1_1ABC8/05/20232547101_814_0115_1_1ABC8/05/20232547101_815_0115_1_1ABC8/05/20232547101_811_0115_1_1ABC8/05/20232547101_812_0115_1_1ABC8/05/20232547101_813_0115_1_1ABC8/05/20232547101_832_0115_1_1DEF1/05/20232547501_806_0115_1_1DEF1/05/20232547501_804_0115_1_1DEF1/05/20232547501_805_0115_1_1DEF1/05/20232547501_801_0115_1_1DEF1/05/20232547501_802_0115_1_1DEF1/05/202325475&nbsp;Sheet 2InvoiceNumberItemIDEnd DateCost Centre2552301_013_0107_1_1_T20230513&nbsp;2552301_013_0107_1_1_T20230506&nbsp;2552301_002_0107_1_1_T20230512&nbsp;2552301_015_0107_1_1_T20230512&nbsp;2552301_014_0107_1_1_T20230507&nbsp;2552301_014_0107_1_1_T20230514&nbsp;2552301_011_0107_1_1_T20230512&nbsp;2554104_170_0136_6_1_T20230508&nbsp;2554104_181_0136_6_1_T20230511&nbsp;2554104_170_0136_6_1_T20230501&nbsp;2554104_181_0136_6_1_T20230504&nbsp;2554304_165_0136_6_1_T20230502&nbsp;2554304_160_0136_6_1_T20230504&nbsp;2554304_165_0136_6_1_T20230503&nbsp;2554304_160_0136_6_1_T20230511&nbsp;2554304_165_0136_6_1_T20230508&nbsp;2554304_165_0136_6_1_T20230505&nbsp;2554304_165_0136_6_1_T20230510&nbsp;

ashish_mathur · Answer

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

babycakes · Answer

Thank you -didnt know this existed&nbsp;

Forum Discussion

Excel formula support

2 Replies

Related content

If formula

Conversion of Excel formulas to DAX within Power BI.

formula

Help with Excel formula

DAX Formula Help

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

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