Salam Master
Saya belum mudeng
Maaf
Assalamualaikum
    Pada Senin, 21 Oktober 2019 16.05.02 GMT+7, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  

karena datanya tidak di-sort berdasar kolom kunci lookup nya
On Mon, Oct 21, 2019 at 3:38 PM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] 
<belajar-excel@yahoogroups.com> wrote:

  

Salam Para Master
Selamat Sore, semoga semua dalam keadaan sehat
Terlampir data lookup, Maaf dari data tersebut ada rumus yang tidak berfungsi 
dan saya tidak paham dimana letak kesalahannya karena ada data yang tidak 
bernilai, mohon solusinya
Terimakasih Banyak
AssalamalaikumHairul Alam


  #yiv7084709709 #yiv7084709709 -- #yiv7084709709ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7084709709 
#yiv7084709709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7084709709 
#yiv7084709709ygrp-mkp #yiv7084709709hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7084709709 #yiv7084709709ygrp-mkp #yiv7084709709ads 
{margin-bottom:10px;}#yiv7084709709 #yiv7084709709ygrp-mkp .yiv7084709709ad 
{padding:0 0;}#yiv7084709709 #yiv7084709709ygrp-mkp .yiv7084709709ad p 
{margin:0;}#yiv7084709709 #yiv7084709709ygrp-mkp .yiv7084709709ad a 
{color:#0000ff;text-decoration:none;}#yiv7084709709 #yiv7084709709ygrp-sponsor 
#yiv7084709709ygrp-lc {font-family:Arial;}#yiv7084709709 
#yiv7084709709ygrp-sponsor #yiv7084709709ygrp-lc #yiv7084709709hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7084709709 
#yiv7084709709ygrp-sponsor #yiv7084709709ygrp-lc .yiv7084709709ad 
{margin-bottom:10px;padding:0 0;}#yiv7084709709 #yiv7084709709actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7084709709 
#yiv7084709709activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7084709709
 #yiv7084709709activity span {font-weight:700;}#yiv7084709709 
#yiv7084709709activity span:first-child 
{text-transform:uppercase;}#yiv7084709709 #yiv7084709709activity span a 
{color:#5085b6;text-decoration:none;}#yiv7084709709 #yiv7084709709activity span 
span {color:#ff7900;}#yiv7084709709 #yiv7084709709activity span 
.yiv7084709709underline {text-decoration:underline;}#yiv7084709709 
.yiv7084709709attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7084709709 .yiv7084709709attach div a 
{text-decoration:none;}#yiv7084709709 .yiv7084709709attach img 
{border:none;padding-right:5px;}#yiv7084709709 .yiv7084709709attach label 
{display:block;margin-bottom:5px;}#yiv7084709709 .yiv7084709709attach label a 
{text-decoration:none;}#yiv7084709709 blockquote {margin:0 0 0 
4px;}#yiv7084709709 .yiv7084709709bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7084709709 
.yiv7084709709bold a {text-decoration:none;}#yiv7084709709 dd.yiv7084709709last 
p a {font-family:Verdana;font-weight:700;}#yiv7084709709 dd.yiv7084709709last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7084709709 
dd.yiv7084709709last p span.yiv7084709709yshortcuts 
{margin-right:0;}#yiv7084709709 div.yiv7084709709attach-table div div a 
{text-decoration:none;}#yiv7084709709 div.yiv7084709709attach-table 
{width:400px;}#yiv7084709709 div.yiv7084709709file-title a, #yiv7084709709 
div.yiv7084709709file-title a:active, #yiv7084709709 
div.yiv7084709709file-title a:hover, #yiv7084709709 div.yiv7084709709file-title 
a:visited {text-decoration:none;}#yiv7084709709 div.yiv7084709709photo-title a, 
#yiv7084709709 div.yiv7084709709photo-title a:active, #yiv7084709709 
div.yiv7084709709photo-title a:hover, #yiv7084709709 
div.yiv7084709709photo-title a:visited {text-decoration:none;}#yiv7084709709 
div#yiv7084709709ygrp-mlmsg #yiv7084709709ygrp-msg p a 
span.yiv7084709709yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7084709709 
.yiv7084709709green {color:#628c2a;}#yiv7084709709 .yiv7084709709MsoNormal 
{margin:0 0 0 0;}#yiv7084709709 o {font-size:0;}#yiv7084709709 
#yiv7084709709photos div {float:left;width:72px;}#yiv7084709709 
#yiv7084709709photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7084709709 
#yiv7084709709photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7084709709
 #yiv7084709709reco-category {font-size:77%;}#yiv7084709709 
#yiv7084709709reco-desc {font-size:77%;}#yiv7084709709 .yiv7084709709replbq 
{margin:4px;}#yiv7084709709 #yiv7084709709ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7084709709 #yiv7084709709ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7084709709 
#yiv7084709709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7084709709 
#yiv7084709709ygrp-mlmsg select, #yiv7084709709 input, #yiv7084709709 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7084709709 
#yiv7084709709ygrp-mlmsg pre, #yiv7084709709 code {font:115% 
monospace;}#yiv7084709709 #yiv7084709709ygrp-mlmsg * 
{line-height:1.22em;}#yiv7084709709 #yiv7084709709ygrp-mlmsg #yiv7084709709logo 
{padding-bottom:10px;}#yiv7084709709 #yiv7084709709ygrp-msg p a 
{font-family:Verdana;}#yiv7084709709 #yiv7084709709ygrp-msg 
p#yiv7084709709attach-count span {color:#1E66AE;font-weight:700;}#yiv7084709709 
#yiv7084709709ygrp-reco #yiv7084709709reco-head 
{color:#ff7900;font-weight:700;}#yiv7084709709 #yiv7084709709ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv7084709709 #yiv7084709709ygrp-sponsor 
#yiv7084709709ov li a {font-size:130%;text-decoration:none;}#yiv7084709709 
#yiv7084709709ygrp-sponsor #yiv7084709709ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7084709709 
#yiv7084709709ygrp-sponsor #yiv7084709709ov ul {margin:0;padding:0 0 0 
8px;}#yiv7084709709 #yiv7084709709ygrp-text 
{font-family:Georgia;}#yiv7084709709 #yiv7084709709ygrp-text p {margin:0 0 1em 
0;}#yiv7084709709 #yiv7084709709ygrp-text tt {font-size:120%;}#yiv7084709709 
#yiv7084709709ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv7084709709   

Kirim email ke