[belajar-excel] Index Match [1 Attachment]

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Index Match [1 Attachment]

Maknawiyah Karim
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
ThanksMakna

=?UTF-8?b?SW5kZXhtYXRjaC54bHM=?= (27K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Index Match

Dede Sulaeman-2
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: [hidden email] [mailto:[hidden email]]
Sent: Thursday, January 17, 2019 9:53 AM
To: [hidden email]
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