Re: [belajar-excel] Rumus gabungan Vlookup

Mon, 24 Nov 2014 22:14:38 -0800 

Mas Fahmi;

Coba begini:
=IFERROR(E43*INDEX($C$4:$G$15,MATCH(RIGHT(D43,6),$A$4:$A$15,0),MATCH(VLOOKUP(LEFT(D43,1),$I$6:$J$10,2,0),$C$3:$G$3,0)),0)
Copas kebawah




Wassalam

~ Bagus ~



  ----- Original Message ----- 
  From: Fahmi Syaifullah [email protected] [belajar-excel] 
  To: [email protected] 
  Sent: Monday, November 24, 2014 8:37 PM
  Subject: [belajar-excel] Rumus gabungan Vlookup [1 Attachment]


    

  Yang terhormat, Bapak / Ibu guru excel




  berikut saya lampirkan suatu soal excel yang kiranya membutuhkan bantuan.
  mohon bantuannya bapak / ibu.
  terimakasih,
  wassalam


  regard,
  fahmi syaifullah

Kirim email ke