Using XLookup or any ideal function, need to return value from range with two or three criteria....

[YansaneYansane]

Hi,

Please, Need help ....Using XLookup or any ideal function to return value from range with two or three criteria (CLIENTS and STATUT)....

In the STATISTIQUE tab, return value in the yellow area based on K5 (column K in STATISTIQUE tab)

Source data will be out of the GESTIONS tab, Column F and Column G or CLIENTS and STATUT for each data element in Column L of GESTIONS tab.


Thank you

 

[Sergius]

Hello! If I understand correctly, this should help.

Book1
	K	L	M	N
4		NON FACTURE	FACTURE	PAYER
5	KGM	0	4	1
6	SMT	1	1	2
STATISTIQUE

Cell Formulas
Range	Formula
L5:N6	L5	=COUNTIFS(GESTIONS!$F$2:$F$10,$K5,GESTIONS!$G$2:$G$10,L$4)

Book1
	F	G
1	CLIENTS	STATUT
2	KGM	PAYER
3	KGM	FACTURE
4	KGM	FACTURE
5	SMT	NON FACTURE
6	KGM	FACTURE
7	SMT	PAYER
8	SMT	PAYER
9	SMT	FACTURE
10	KGM	FACTURE
GESTIONS

 

[YansaneYansane]

Hi Sergius,

Thanks much for the help. This worked flawlessly...