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 Zhe [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.
#yiv6567539585 #yiv6567539585 -- #yiv6567539585ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6567539585
#yiv6567539585ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6567539585
#yiv6567539585ygrp-mkp #yiv6567539585hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6567539585 #yiv6567539585ygrp-mkp #yiv6567539585ads
{margin-bottom:10px;}#yiv6567539585 #yiv6567539585ygrp-mkp .yiv6567539585ad
{padding:0 0;}#yiv6567539585 #yiv6567539585ygrp-mkp .yiv6567539585ad p
{margin:0;}#yiv6567539585 #yiv6567539585ygrp-mkp .yiv6567539585ad a
{color:#0000ff;text-decoration:none;}#yiv6567539585 #yiv6567539585ygrp-sponsor
#yiv6567539585ygrp-lc {font-family:Arial;}#yiv6567539585
#yiv6567539585ygrp-sponsor #yiv6567539585ygrp-lc #yiv6567539585hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6567539585
#yiv6567539585ygrp-sponsor #yiv6567539585ygrp-lc .yiv6567539585ad
{margin-bottom:10px;padding:0 0;}#yiv6567539585 #yiv6567539585actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6567539585
#yiv6567539585activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6567539585
#yiv6567539585activity span {font-weight:700;}#yiv6567539585
#yiv6567539585activity span:first-child
{text-transform:uppercase;}#yiv6567539585 #yiv6567539585activity span a
{color:#5085b6;text-decoration:none;}#yiv6567539585 #yiv6567539585activity span
span {color:#ff7900;}#yiv6567539585 #yiv6567539585activity span
.yiv6567539585underline {text-decoration:underline;}#yiv6567539585
.yiv6567539585attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6567539585 .yiv6567539585attach div a
{text-decoration:none;}#yiv6567539585 .yiv6567539585attach img
{border:none;padding-right:5px;}#yiv6567539585 .yiv6567539585attach label
{display:block;margin-bottom:5px;}#yiv6567539585 .yiv6567539585attach label a
{text-decoration:none;}#yiv6567539585 blockquote {margin:0 0 0
4px;}#yiv6567539585 .yiv6567539585bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6567539585
.yiv6567539585bold a {text-decoration:none;}#yiv6567539585 dd.yiv6567539585last
p a {font-family:Verdana;font-weight:700;}#yiv6567539585 dd.yiv6567539585last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6567539585
dd.yiv6567539585last p span.yiv6567539585yshortcuts
{margin-right:0;}#yiv6567539585 div.yiv6567539585attach-table div div a
{text-decoration:none;}#yiv6567539585 div.yiv6567539585attach-table
{width:400px;}#yiv6567539585 div.yiv6567539585file-title a, #yiv6567539585
div.yiv6567539585file-title a:active, #yiv6567539585
div.yiv6567539585file-title a:hover, #yiv6567539585 div.yiv6567539585file-title
a:visited {text-decoration:none;}#yiv6567539585 div.yiv6567539585photo-title a,
#yiv6567539585 div.yiv6567539585photo-title a:active, #yiv6567539585
div.yiv6567539585photo-title a:hover, #yiv6567539585
div.yiv6567539585photo-title a:visited {text-decoration:none;}#yiv6567539585
div#yiv6567539585ygrp-mlmsg #yiv6567539585ygrp-msg p a
span.yiv6567539585yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6567539585
.yiv6567539585green {color:#628c2a;}#yiv6567539585 .yiv6567539585MsoNormal
{margin:0 0 0 0;}#yiv6567539585 o {font-size:0;}#yiv6567539585
#yiv6567539585photos div {float:left;width:72px;}#yiv6567539585
#yiv6567539585photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6567539585
#yiv6567539585photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6567539585
#yiv6567539585reco-category {font-size:77%;}#yiv6567539585
#yiv6567539585reco-desc {font-size:77%;}#yiv6567539585 .yiv6567539585replbq
{margin:4px;}#yiv6567539585 #yiv6567539585ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6567539585 #yiv6567539585ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6567539585
#yiv6567539585ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6567539585
#yiv6567539585ygrp-mlmsg select, #yiv6567539585 input, #yiv6567539585 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6567539585
#yiv6567539585ygrp-mlmsg pre, #yiv6567539585 code {font:115%
monospace;}#yiv6567539585 #yiv6567539585ygrp-mlmsg *
{line-height:1.22em;}#yiv6567539585 #yiv6567539585ygrp-mlmsg #yiv6567539585logo
{padding-bottom:10px;}#yiv6567539585 #yiv6567539585ygrp-msg p a
{font-family:Verdana;}#yiv6567539585 #yiv6567539585ygrp-msg
p#yiv6567539585attach-count span {color:#1E66AE;font-weight:700;}#yiv6567539585
#yiv6567539585ygrp-reco #yiv6567539585reco-head
{color:#ff7900;font-weight:700;}#yiv6567539585 #yiv6567539585ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6567539585 #yiv6567539585ygrp-sponsor
#yiv6567539585ov li a {font-size:130%;text-decoration:none;}#yiv6567539585
#yiv6567539585ygrp-sponsor #yiv6567539585ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6567539585
#yiv6567539585ygrp-sponsor #yiv6567539585ov ul {margin:0;padding:0 0 0
8px;}#yiv6567539585 #yiv6567539585ygrp-text
{font-family:Georgia;}#yiv6567539585 #yiv6567539585ygrp-text p {margin:0 0 1em
0;}#yiv6567539585 #yiv6567539585ygrp-text tt {font-size:120%;}#yiv6567539585
#yiv6567539585ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6567539585
