Formula Help.

[mazher]

Please can someone help me with

Invoice Number	Result I am getting	Result I Need		Sr	Invoice No	Initial Email	2nd Email	3rd Email	4th Email	5th Email	6th Email
A	06/07/2022​	22/03/2023​		1​	A	06/07/2022​	12/10/2022​	12/10/2022​	19/10/2022​	09/02/2023​	22/03/2023​
B	11/11/2020​	06/07/2021​		2​	B	11/11/2020​	18/11/2020​	24/11/2020​	18/04/2021​	06/07/2021​
C	11/11/2020​	01/06/2021​		3​	C	11/11/2020​	24/11/2020​	18/04/2021​	23/04/2021​	01/06/2021​
D	14/12/2021​	09/02/2023​		4​	D	14/12/2021​	31/03/2022​	22/04/2022​	09/05/2022​	09/02/2023​
F	05/09/2020​	06/07/2021​		5​	E	09/02/2023​	16/02/2023​	22/03/2023​	16/12/2023​	18/12/2023​
P	02/04/2024​	02/04/2024​		6​	F	05/09/2020​	01/06/2021​	24/06/2021​	06/07/2021​
				7​	G	11/11/2020​	24/11/2020​	18/04/2021​	01/06/2021​
				8​	H	12/02/2022​	22/04/2022​	09/05/2022​	09/02/2023​
				9​	I	22/06/2022​	02/08/2022​	12/10/2022​	12/10/2022​
				10​	J	22/06/2022​	10/08/2022​	12/10/2022​	12/10/2022​
				11​	K	06/07/2022​	02/08/2022​	12/10/2022​	12/10/2022​
				12​	L	09/02/2023​	16/02/2023​	16/12/2023​	18/12/2023​
				13​	M	09/02/2023​	16/02/2023​	24/02/2023​	22/03/2023​
				14​	N	09/02/2023​	16/02/2023​	16/12/2023​	18/12/2023​
				15​	O	06/02/2020​	03/03/2020​	25/04/2020​
				16​	P	02/04/2024​

I am using this foruma in Cell AB3 =XLOOKUP(AA3:AA8,AF3:AF19,AG3:AL19,"",0,-1)
Basically I need the last date the email was sent for a particular invoice.
Any help will be appreciated.

Thanks

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Invoice Number	Result I am getting			Sr	Invoice No	Initial Email	2nd Email	3rd Email	4th Email	5th Email	6th Email
2	A	22/03/2023			1	A	06/07/2022	12/10/2022	12/10/2022	19/10/2022	09/02/2023	22/03/2023
3	B	06/07/2021			2	B	11/11/2020	18/11/2020	24/11/2020	18/04/2021	06/07/2021
4	C	01/06/2021			3	C	11/11/2020	24/11/2020	18/04/2021	23/04/2021	01/06/2021
5	D	09/02/2023			4	D	14/12/2021	31/03/2022	22/04/2022	09/05/2022	09/02/2023
6	F	06/07/2021			5	E	09/02/2023	16/02/2023	22/03/2023	16/12/2023	18/12/2023
7	P	02/04/2024			6	F	05/09/2020	01/06/2021	24/06/2021	06/07/2021
8					7	G	11/11/2020	24/11/2020	18/04/2021	01/06/2021
9					8	H	12/02/2022	22/04/2022	09/05/2022	09/02/2023
10					9	I	22/06/2022	02/08/2022	12/10/2022	12/10/2022
11					10	J	22/06/2022	10/08/2022	12/10/2022	12/10/2022
12					11	K	06/07/2022	02/08/2022	12/10/2022	12/10/2022
13					12	L	09/02/2023	16/02/2023	16/12/2023	18/12/2023
14					13	M	09/02/2023	16/02/2023	24/02/2023	22/03/2023
15					14	N	09/02/2023	16/02/2023	16/12/2023	18/12/2023
16					15	O	06/02/2020	03/03/2020	25/04/2020
17					16	P	02/04/2024
18
Sheet4

Cell Formulas
Range	Formula
B2:B7	B2	=MAX(XLOOKUP(A2,$F$2:$F$100,$G$2:$L$100,"",0))

 

[mazher]

Thanks Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.