Dear Mas Jody dan Mas Hendrik..makasih banyak atas pencerahan dan kesediaan
memberi jawaban...
Salam sukses selalu ,
Teti.
On Tuesday, March 17, 2015 11:59 AM, "Jody Roostandy [email protected]
[belajar-excel]" <[email protected]> wrote:
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
yangexact dari kode “SK” di “Tabel Perbandingan” 1, menandakan “True”
(approximate match), yang dalam kasus contoh data berarti Hlookup akan mencari
padanan yang merupakanpendekatan 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] [belajar-excel]" <[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
[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.
#yiv7524262548 #yiv7524262548 -- #yiv7524262548ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7524262548
#yiv7524262548ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7524262548
#yiv7524262548ygrp-mkp #yiv7524262548hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7524262548 #yiv7524262548ygrp-mkp #yiv7524262548ads
{margin-bottom:10px;}#yiv7524262548 #yiv7524262548ygrp-mkp .yiv7524262548ad
{padding:0 0;}#yiv7524262548 #yiv7524262548ygrp-mkp .yiv7524262548ad p
{margin:0;}#yiv7524262548 #yiv7524262548ygrp-mkp .yiv7524262548ad a
{color:#0000ff;text-decoration:none;}#yiv7524262548 #yiv7524262548ygrp-sponsor
#yiv7524262548ygrp-lc {font-family:Arial;}#yiv7524262548
#yiv7524262548ygrp-sponsor #yiv7524262548ygrp-lc #yiv7524262548hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7524262548
#yiv7524262548ygrp-sponsor #yiv7524262548ygrp-lc .yiv7524262548ad
{margin-bottom:10px;padding:0 0;}#yiv7524262548 #yiv7524262548actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7524262548
#yiv7524262548activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7524262548
#yiv7524262548activity span {font-weight:700;}#yiv7524262548
#yiv7524262548activity span:first-child
{text-transform:uppercase;}#yiv7524262548 #yiv7524262548activity span a
{color:#5085b6;text-decoration:none;}#yiv7524262548 #yiv7524262548activity span
span {color:#ff7900;}#yiv7524262548 #yiv7524262548activity span
.yiv7524262548underline {text-decoration:underline;}#yiv7524262548
.yiv7524262548attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7524262548 .yiv7524262548attach div a
{text-decoration:none;}#yiv7524262548 .yiv7524262548attach img
{border:none;padding-right:5px;}#yiv7524262548 .yiv7524262548attach label
{display:block;margin-bottom:5px;}#yiv7524262548 .yiv7524262548attach label a
{text-decoration:none;}#yiv7524262548 blockquote {margin:0 0 0
4px;}#yiv7524262548 .yiv7524262548bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7524262548
.yiv7524262548bold a {text-decoration:none;}#yiv7524262548 dd.yiv7524262548last
p a {font-family:Verdana;font-weight:700;}#yiv7524262548 dd.yiv7524262548last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7524262548
dd.yiv7524262548last p span.yiv7524262548yshortcuts
{margin-right:0;}#yiv7524262548 div.yiv7524262548attach-table div div a
{text-decoration:none;}#yiv7524262548 div.yiv7524262548attach-table
{width:400px;}#yiv7524262548 div.yiv7524262548file-title a, #yiv7524262548
div.yiv7524262548file-title a:active, #yiv7524262548
div.yiv7524262548file-title a:hover, #yiv7524262548 div.yiv7524262548file-title
a:visited {text-decoration:none;}#yiv7524262548 div.yiv7524262548photo-title a,
#yiv7524262548 div.yiv7524262548photo-title a:active, #yiv7524262548
div.yiv7524262548photo-title a:hover, #yiv7524262548
div.yiv7524262548photo-title a:visited {text-decoration:none;}#yiv7524262548
div#yiv7524262548ygrp-mlmsg #yiv7524262548ygrp-msg p a
span.yiv7524262548yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7524262548
.yiv7524262548green {color:#628c2a;}#yiv7524262548 .yiv7524262548MsoNormal
{margin:0 0 0 0;}#yiv7524262548 o {font-size:0;}#yiv7524262548
#yiv7524262548photos div {float:left;width:72px;}#yiv7524262548
#yiv7524262548photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7524262548
#yiv7524262548photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7524262548
#yiv7524262548reco-category {font-size:77%;}#yiv7524262548
#yiv7524262548reco-desc {font-size:77%;}#yiv7524262548 .yiv7524262548replbq
{margin:4px;}#yiv7524262548 #yiv7524262548ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7524262548 #yiv7524262548ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7524262548
#yiv7524262548ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7524262548
#yiv7524262548ygrp-mlmsg select, #yiv7524262548 input, #yiv7524262548 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7524262548
#yiv7524262548ygrp-mlmsg pre, #yiv7524262548 code {font:115%
monospace;}#yiv7524262548 #yiv7524262548ygrp-mlmsg *
{line-height:1.22em;}#yiv7524262548 #yiv7524262548ygrp-mlmsg #yiv7524262548logo
{padding-bottom:10px;}#yiv7524262548 #yiv7524262548ygrp-msg p a
{font-family:Verdana;}#yiv7524262548 #yiv7524262548ygrp-msg
p#yiv7524262548attach-count span {color:#1E66AE;font-weight:700;}#yiv7524262548
#yiv7524262548ygrp-reco #yiv7524262548reco-head
{color:#ff7900;font-weight:700;}#yiv7524262548 #yiv7524262548ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7524262548 #yiv7524262548ygrp-sponsor
#yiv7524262548ov li a {font-size:130%;text-decoration:none;}#yiv7524262548
#yiv7524262548ygrp-sponsor #yiv7524262548ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7524262548
#yiv7524262548ygrp-sponsor #yiv7524262548ov ul {margin:0;padding:0 0 0
8px;}#yiv7524262548 #yiv7524262548ygrp-text
{font-family:Georgia;}#yiv7524262548 #yiv7524262548ygrp-text p {margin:0 0 1em
0;}#yiv7524262548 #yiv7524262548ygrp-text tt {font-size:120%;}#yiv7524262548
#yiv7524262548ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7524262548
