Dear mbak Teti, Sumbang pendapat dari newbie, untuk kolom terakhir, yaitu “range lookup”
diisi angka 0 atau 1 0, menandakan “false” (exact match), yang dalam kasus contoh data berarti Hlookup akan mencari padanan yang exact dari kode “SK” di “Tabel Perbandingan” 1, menandakan “True” (approximate match), yang dalam kasus contoh data berarti Hlookup akan mencari padanan yang merupakan pendekatan dari kode “SK” di “Tabel Perbandingan” Regards, Jody Roostandy From: [email protected] [mailto:[email protected]] Sent: 16 Maret 2015 14:55 To: [email protected] Subject: Re: [belajar-excel] mohon tanya tentang penggunaan HLOOKUP Dear Mas Heri, trims mas... yang terakhir berfungsi untuk apa tha? hehe... semoga dapet pencerahan selanjtnya dari master yang lain.... trims... Salam, Teti. On Monday, March 16, 2015 12:29 PM, "'Heri Pamungkas ( Gmail )' [email protected]<mailto:[email protected]> [belajar-excel]" <[email protected]<mailto:[email protected]>> wrote: السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ Semangat pagi,. Sepertinya kurang Range Lookupnya. =HLOOKUP(A4;$F$2:$J$3;2;0) Untuk kenapanya mungkin ada Be-Exceller lain yang bisa menjelaskan. hehehehe..... وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ Warm Regards, On 16/03/2015 10:24, Teti Zhe [email protected]<mailto:[email protected]> [belajar-excel] wrote: Dear master excel.. saya masih pemula di excel, mau nanya koq di soal terlampir jika memakai rumus hlookup, pada kode SK yang seharusnya tertulis Sekretaris malah tertulis Marketing? apakah cara saya sudah benar? makasih banyak sebelumnya atas bantuannya... Salam, Teti. This email (including any attachments) contains information that is privileged or confidential and is intended solely for the individual/entity/addressee named herein. The sending of this email to any person other than the intended recipient is not a waiver of the privilege or confidentiality that attaches to it. If you are not the intended recipient, please do not read this email and notify us immediately and delete the email. You should not disclose copy or distribute this email. Any such action taken by you is strictly prohibited and may be unlawful. Email transmission may be subject to error due to unauthorized interceptions, interferences, corruption or virus. Neither the sender nor the represented organization ensures error-free and complete transmission of the contents of this email or its timely receipt. Please verify your doubts directly with us. PT Abacus Distribution Systems Indonesia ("the Company") does not accept any liability in respect of communication made by its employee who is contrary to the company policy or outside the scope of the employment of the individual concerned. The employee responsible will be personally liable for any damages or other liability arising.
