Convert index math excel get data different sheet

synard
New Member

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

0 1 88
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

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.

Top Labels in this Space