Multiple Lookup array

[Al Yasfy]

How to fill Bonus % column with formula from table 2 in google sheet?

 

[DanteAmor]

Hi @Al Yasfy.
Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

It seems to me that in google sheet you can use SUMIFS:

Dante Amor
	A	B	C	D	E	F	G	H												T	U	V	W
1			Name	Gender	Dep	Date	Salary	Bonus													Dep	Gender	Bonus
2				Female	Procu			5%													Finance	Female	4%
3				Female	Sales			3%													Procu	Female	5%
4				Male	Sales			4%													Sales	Female	3%
5																					Website	Female	6%
6																					Finance	Male	3%
7																					Procu	Male	4%
8																					Sales	Male	4%
9																					Website	Male	5%
Hoja1

Cell Formulas
Range	Formula
H2:H4	H2	=SUMIFS($W$2:$W$9,$U$2:$U$9,E2,$V$2:$V$9,D2)

--------------
Sincerely
Dante Amor
--------------