Mas Fahmi; Sila lihat file terlampir..
Wassalam ~ Bagus ~ ----- Original Message ----- From: Fahmi Syaifullah [email protected] [belajar-excel] To: [email protected] Sent: Tuesday, November 25, 2014 7:31 PM Subject: Bls: [belajar-excel] Rumus gabungan Vlookup yang terhormat pak bagus. saya sudah coba formulanya, tapi kok hasinya nol yaa? mohon bantuannya . wassalam fahmi syaifullah Pada Selasa, 25 November 2014 13:13, "'Bagus' [email protected] [belajar-excel]" <[email protected]> menulis: 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
Bugs - soal dan latihan 2.10.xlsx
Description: MS-Excel 2007 spreadsheet
