Dear Makna,
Kondisi match ROW-nya terbalik. =INDEX($B$3:$D$5,MATCH($A10,$A$3:$A$5,0),MATCH(B$9,$B$2:$D$2,0)) Salam, DD From: [email protected] [mailto:[email protected]] Sent: Thursday, January 17, 2019 9:53 AM To: [email protected] Subject: [belajar-excel] Index Match [1 Attachment] Dear All Mohon dibantu untuk case berikut dimana Saya ingin mencari hasil A dengan jenis AA, BB dan CC, kendalanya kenapa row A membaca secara vertikal (100, 150, 175) di sumber data ya..? harusnya membaca horizontal (100, 200, 300), terlampir Thanks Makna
