Ini penjelasan yang saya dapat dari internet:
SyntaxHLOOKUP(lookup_value,table_array,row_index_num,range_lookup)Lookup_value
is the value to be found in the first row of the table. Lookup_value can be
a value, a reference, or a text string.Table_array is a table of
information in which data is looked up. Use a reference to a range or a range
name.
- The values in the first row of table_array can be text, numbers, or
logical values.
- If range_lookup is TRUE, the values in the first row of table_array must
be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE;
otherwise, HLOOKUP may not give the correct value. If range_lookup is FALSE,
table_array does not need to be sorted.
- Uppercase and lowercase text are equivalent.
- Sort the values in ascending order, left to right. For more information,
see Sort data.
Row_index_num is the row number in table_array from which the matching
value will be returned. A row_index_num of 1 returns the first row value in
table_array, a row_index_num of 2 returns the second row value in table_array,
and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error
value; if row_index_num is greater than the number of rows on table_array,
HLOOKUP returns the #REF! error value.Range_lookup is a logical value that
specifies whether you want HLOOKUP to find an exact match or an approximate
match. If TRUE or omitted, an approximate match is returned. In other words, if
an exact match is not found, the next largest value that is less than
lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is
not found, the error value #N/A is returned.
Salam,HK
----- Forwarded Message -----
From: "'Heri Pamungkas ( Gmail )' [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 16 March 2015, 12:25
Subject: Re: [belajar-excel] mohon tanya tentang penggunaan HLOOKUP
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
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.
#yiv6564552156 #yiv6564552156 -- #yiv6564552156ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6564552156
#yiv6564552156ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6564552156
#yiv6564552156ygrp-mkp #yiv6564552156hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6564552156 #yiv6564552156ygrp-mkp #yiv6564552156ads
{margin-bottom:10px;}#yiv6564552156 #yiv6564552156ygrp-mkp .yiv6564552156ad
{padding:0 0;}#yiv6564552156 #yiv6564552156ygrp-mkp .yiv6564552156ad p
{margin:0;}#yiv6564552156 #yiv6564552156ygrp-mkp .yiv6564552156ad a
{color:#0000ff;text-decoration:none;}#yiv6564552156 #yiv6564552156ygrp-sponsor
#yiv6564552156ygrp-lc {font-family:Arial;}#yiv6564552156
#yiv6564552156ygrp-sponsor #yiv6564552156ygrp-lc #yiv6564552156hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6564552156
#yiv6564552156ygrp-sponsor #yiv6564552156ygrp-lc .yiv6564552156ad
{margin-bottom:10px;padding:0 0;}#yiv6564552156 #yiv6564552156actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6564552156
#yiv6564552156activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6564552156
#yiv6564552156activity span {font-weight:700;}#yiv6564552156
#yiv6564552156activity span:first-child
{text-transform:uppercase;}#yiv6564552156 #yiv6564552156activity span a
{color:#5085b6;text-decoration:none;}#yiv6564552156 #yiv6564552156activity span
span {color:#ff7900;}#yiv6564552156 #yiv6564552156activity span
.yiv6564552156underline {text-decoration:underline;}#yiv6564552156
.yiv6564552156attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6564552156 .yiv6564552156attach div a
{text-decoration:none;}#yiv6564552156 .yiv6564552156attach img
{border:none;padding-right:5px;}#yiv6564552156 .yiv6564552156attach label
{display:block;margin-bottom:5px;}#yiv6564552156 .yiv6564552156attach label a
{text-decoration:none;}#yiv6564552156 blockquote {margin:0 0 0
4px;}#yiv6564552156 .yiv6564552156bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6564552156
.yiv6564552156bold a {text-decoration:none;}#yiv6564552156 dd.yiv6564552156last
p a {font-family:Verdana;font-weight:700;}#yiv6564552156 dd.yiv6564552156last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6564552156
dd.yiv6564552156last p span.yiv6564552156yshortcuts
{margin-right:0;}#yiv6564552156 div.yiv6564552156attach-table div div a
{text-decoration:none;}#yiv6564552156 div.yiv6564552156attach-table
{width:400px;}#yiv6564552156 div.yiv6564552156file-title a, #yiv6564552156
div.yiv6564552156file-title a:active, #yiv6564552156
div.yiv6564552156file-title a:hover, #yiv6564552156 div.yiv6564552156file-title
a:visited {text-decoration:none;}#yiv6564552156 div.yiv6564552156photo-title a,
#yiv6564552156 div.yiv6564552156photo-title a:active, #yiv6564552156
div.yiv6564552156photo-title a:hover, #yiv6564552156
div.yiv6564552156photo-title a:visited {text-decoration:none;}#yiv6564552156
div#yiv6564552156ygrp-mlmsg #yiv6564552156ygrp-msg p a
span.yiv6564552156yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6564552156
.yiv6564552156green {color:#628c2a;}#yiv6564552156 .yiv6564552156MsoNormal
{margin:0 0 0 0;}#yiv6564552156 o {font-size:0;}#yiv6564552156
#yiv6564552156photos div {float:left;width:72px;}#yiv6564552156
#yiv6564552156photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6564552156
#yiv6564552156photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6564552156
#yiv6564552156reco-category {font-size:77%;}#yiv6564552156
#yiv6564552156reco-desc {font-size:77%;}#yiv6564552156 .yiv6564552156replbq
{margin:4px;}#yiv6564552156 #yiv6564552156ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6564552156 #yiv6564552156ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6564552156
#yiv6564552156ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6564552156
#yiv6564552156ygrp-mlmsg select, #yiv6564552156 input, #yiv6564552156 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6564552156
#yiv6564552156ygrp-mlmsg pre, #yiv6564552156 code {font:115%
monospace;}#yiv6564552156 #yiv6564552156ygrp-mlmsg *
{line-height:1.22em;}#yiv6564552156 #yiv6564552156ygrp-mlmsg #yiv6564552156logo
{padding-bottom:10px;}#yiv6564552156 #yiv6564552156ygrp-msg p a
{font-family:Verdana;}#yiv6564552156 #yiv6564552156ygrp-msg
p#yiv6564552156attach-count span {color:#1E66AE;font-weight:700;}#yiv6564552156
#yiv6564552156ygrp-reco #yiv6564552156reco-head
{color:#ff7900;font-weight:700;}#yiv6564552156 #yiv6564552156ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6564552156 #yiv6564552156ygrp-sponsor
#yiv6564552156ov li a {font-size:130%;text-decoration:none;}#yiv6564552156
#yiv6564552156ygrp-sponsor #yiv6564552156ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6564552156
#yiv6564552156ygrp-sponsor #yiv6564552156ov ul {margin:0;padding:0 0 0
8px;}#yiv6564552156 #yiv6564552156ygrp-text
{font-family:Georgia;}#yiv6564552156 #yiv6564552156ygrp-text p {margin:0 0 1em
0;}#yiv6564552156 #yiv6564552156ygrp-text tt {font-size:120%;}#yiv6564552156
#yiv6564552156ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6564552156
