Modifikasi rumusnya macem petirrr, terima kasih Mr Kid atas pencerahannya.

yang bodoh
budi


________________________________
From: Mr. Kid <[email protected]>
To: [email protected]
Sent: Saturday, August 6, 2011 12:05 PM
Subject: Re: [belajar-excel] Tabel Formula - Formula Tabel

 
Coba juga.
=INDEX($C$9:$H$25,MATCH($K10,$A$8:$A$20,0)+COLUMNS($M$9:M$9),MATCH($L10,$C$9:$H$9,0))

Kid.

Kirim email ke