hi,
can someone help me to convert this formula please
=INDEX(Kapasitas!$D$2:$D$6,MATCH(1,(I2=Kapasitas!$A$2:$A$6)*(K2=Kapasitas!$B$2:$B$6),0))
i created this formula in my xls file and it works, but i still confuse to convert this into appsheet compatible
Hi @synard
Welcome to the community !
Can you please share your tables structures and explain what you intend to do with this expression ?
Screenshot are best.
User | Count |
---|---|
18 | |
10 | |
8 | |
5 | |
5 |