Bls: Re: [belajar-excel] Vlookup tidak sesuai

2018-01-16 Terurut Topik luddy subiyandoko luddy_subiyand...@yahoo.co.id [belajar-excel] 

Ok mr kid terima kasih info

Dikirim dari Yahoo Mail di Android

  Pada Sel, 16 Jan 2018 pada 19:12, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] menulis:    

Hai Subi,
Coba datanya di-sort ascending, lalu pakai match type BUKAN numerik 0 (di 
vlookup dan hlookup disebut range lookup atau approximate match). Nilai 0 
setara FALSE, BUKAN numerik 0 setara TRUE.

lookup di Excel
> vlookup dan hlookup menggunakan match type 0 (kosong atau true atau exact), 
> match dengan match type 0 atau exact : data boleh unsorted
> vlookup, hlookup, dan lookup menggunakan match type BUKAN 0 (atau false atau 
> approximate), match dengan match type 1 atau less then : data HARUS sorted 
> ascending
> match dengan match type -1 atau greater then : data HARUS sorted descending

Regards,Kid


2018-01-16 12:38 GMT+07:00 luddy subiyandoko luddy_subiyand...@yahoo.co.id 
[belajar-excel] :

  
Mohon bantuan master

Ini saya mempunyai kendala terkait rumus vlookup yg tidak sesuai dengan 
hasilnya.
Mohon bantuan petunjuknya

Dikirim dari Yahoo Mail di Android



  #yiv3641944215 #yiv3641944215 -- #yiv3641944215ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3641944215 
#yiv3641944215ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3641944215 
#yiv3641944215ygrp-mkp #yiv3641944215hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3641944215 #yiv3641944215ygrp-mkp #yiv3641944215ads 
{margin-bottom:10px;}#yiv3641944215 #yiv3641944215ygrp-mkp .yiv3641944215ad 
{padding:0 0;}#yiv3641944215 #yiv3641944215ygrp-mkp .yiv3641944215ad p 
{margin:0;}#yiv3641944215 #yiv3641944215ygrp-mkp .yiv3641944215ad a 
{color:#ff;text-decoration:none;}#yiv3641944215 #yiv3641944215ygrp-sponsor 
#yiv3641944215ygrp-lc {font-family:Arial;}#yiv3641944215 
#yiv3641944215ygrp-sponsor #yiv3641944215ygrp-lc #yiv3641944215hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3641944215 
#yiv3641944215ygrp-sponsor #yiv3641944215ygrp-lc .yiv3641944215ad 
{margin-bottom:10px;padding:0 0;}#yiv3641944215 #yiv3641944215actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3641944215 
#yiv3641944215activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3641944215
 #yiv3641944215activity span {font-weight:700;}#yiv3641944215 
#yiv3641944215activity span:first-child 
{text-transform:uppercase;}#yiv3641944215 #yiv3641944215activity span a 
{color:#5085b6;text-decoration:none;}#yiv3641944215 #yiv3641944215activity span 
span {color:#ff7900;}#yiv3641944215 #yiv3641944215activity span 
.yiv3641944215underline {text-decoration:underline;}#yiv3641944215 
.yiv3641944215attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3641944215 .yiv3641944215attach div a 
{text-decoration:none;}#yiv3641944215 .yiv3641944215attach img 
{border:none;padding-right:5px;}#yiv3641944215 .yiv3641944215attach label 
{display:block;margin-bottom:5px;}#yiv3641944215 .yiv3641944215attach label a 
{text-decoration:none;}#yiv3641944215 blockquote {margin:0 0 0 
4px;}#yiv3641944215 .yiv3641944215bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3641944215 
.yiv3641944215bold a {text-decoration:none;}#yiv3641944215 dd.yiv3641944215last 
p a {font-family:Verdana;font-weight:700;}#yiv3641944215 dd.yiv3641944215last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3641944215 
dd.yiv3641944215last p span.yiv3641944215yshortcuts 
{margin-right:0;}#yiv3641944215 div.yiv3641944215attach-table div div a 
{text-decoration:none;}#yiv3641944215 div.yiv3641944215attach-table 
{width:400px;}#yiv3641944215 div.yiv3641944215file-title a, #yiv3641944215 
div.yiv3641944215file-title a:active, #yiv3641944215 
div.yiv3641944215file-title a:hover, #yiv3641944215 div.yiv3641944215file-title 
a:visited {text-decoration:none;}#yiv3641944215 div.yiv3641944215photo-title a, 
#yiv3641944215 div.yiv3641944215photo-title a:active, #yiv3641944215 
div.yiv3641944215photo-title a:hover, #yiv3641944215 
div.yiv3641944215photo-title a:visited {text-decoration:none;}#yiv3641944215 
div#yiv3641944215ygrp-mlmsg #yiv3641944215ygrp-msg p a 
span.yiv3641944215yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3641944215 
.yiv3641944215green {color:#628c2a;}#yiv3641944215 .yiv3641944215MsoNormal 
{margin:0 0 0 0;}#yiv3641944215 o {font-size:0;}#yiv3641944215 
#yiv3641944215photos div {float:left;width:72px;}#yiv3641944215 
#yiv3641944215photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv3641944215 
#yiv3641944215photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3641944215
 #yiv3641944215reco-category {font-size:77%;}#yiv3641944215 
#yiv3641944215reco-desc {font-size:77%;}#yiv3641944215 .yiv3641944215replbq 
{margin:4px;}#yiv3641944215

Bls: Re: [belajar-excel] Vlookup tidak sesuai

2018-01-16 Terurut Topik Fahmi Syaifullah fahmisyaifulla...@yahoo.com [belajar-excel] 
Bantu sedikit yaak.
fungsi lookup (pencarian) rata2 dimiliki oleh vlookup dan match ada sub 
(pkoknya ketik vlookup terus liat dibawa tuh ada petunjuk nah itu) yang bernama 
range lookup. Diisi True atau setara angka satu atau tidak diisi. Membuat rumus 
mencari sesuai tingkatan. =vlookup(cari_ini,ditabel_ini,kolom_2,1)jika false 
atau diisi 0 . Membuat rumus menjadi exact. HARUS SESUAI.
coba searching2 tntng rumus vlookup ini.banyakk kok.. rumus sangat simple tp 
sangat berguna. 
Mudah2an paham yaa hehe
terima kasihfahmi
Dikirim dari Yahoo Mail di Android 
 
  Pada Sel, 16 Jan 2018 pada 14:19, luddy subiyandoko 
luddy_subiyand...@yahoo.co.id [belajar-excel] 
menulis:       
Terima kasih sarannya pak abdi

 Kalau apabila yg dicari - 1.64101, kan kalau gak sama gak bisa muncul 
hasilnya, nah itu seperti apa ya pak

Dikirim dari Yahoo Mail di Android 
 
  Pada Sel, 16 Jan 2018 pada 13:20, Abu Abdillaah abuabdillaa...@gmail.com 
[belajar-excel] menulis:       

Dear Pak Luddy
Coba rumus diganti seperti berikut:=VLOOKUP(K340,F330:G346,2,0)

Best regards,
2018-01-16 12:38 GMT+07:00 luddy subiyandoko luddy_subiyand...@yahoo.co.id 
[belajar-excel] :

     
Mohon bantuan master

Ini saya mempunyai kendala terkait rumus vlookup yg tidak sesuai dengan 
hasilnya.
Mohon bantuan petunjuknya

Dikirim dari Yahoo Mail di Android

   


  #yiv1823343274 #yiv1823343274 -- #yiv1823343274ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1823343274 
#yiv1823343274ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1823343274 
#yiv1823343274ygrp-mkp #yiv1823343274hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1823343274 #yiv1823343274ygrp-mkp #yiv1823343274ads 
{margin-bottom:10px;}#yiv1823343274 #yiv1823343274ygrp-mkp .yiv1823343274ad 
{padding:0 0;}#yiv1823343274 #yiv1823343274ygrp-mkp .yiv1823343274ad p 
{margin:0;}#yiv1823343274 #yiv1823343274ygrp-mkp .yiv1823343274ad a 
{color:#ff;text-decoration:none;}#yiv1823343274 #yiv1823343274ygrp-sponsor 
#yiv1823343274ygrp-lc {font-family:Arial;}#yiv1823343274 
#yiv1823343274ygrp-sponsor #yiv1823343274ygrp-lc #yiv1823343274hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1823343274 
#yiv1823343274ygrp-sponsor #yiv1823343274ygrp-lc .yiv1823343274ad 
{margin-bottom:10px;padding:0 0;}#yiv1823343274 #yiv1823343274actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1823343274 
#yiv1823343274activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1823343274
 #yiv1823343274activity span {font-weight:700;}#yiv1823343274 
#yiv1823343274activity span:first-child 
{text-transform:uppercase;}#yiv1823343274 #yiv1823343274activity span a 
{color:#5085b6;text-decoration:none;}#yiv1823343274 #yiv1823343274activity span 
span {color:#ff7900;}#yiv1823343274 #yiv1823343274activity span 
.yiv1823343274underline {text-decoration:underline;}#yiv1823343274 
.yiv1823343274attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1823343274 .yiv1823343274attach div a 
{text-decoration:none;}#yiv1823343274 .yiv1823343274attach img 
{border:none;padding-right:5px;}#yiv1823343274 .yiv1823343274attach label 
{display:block;margin-bottom:5px;}#yiv1823343274 .yiv1823343274attach label a 
{text-decoration:none;}#yiv1823343274 blockquote {margin:0 0 0 
4px;}#yiv1823343274 .yiv1823343274bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1823343274 
.yiv1823343274bold a {text-decoration:none;}#yiv1823343274 dd.yiv1823343274last 
p a {font-family:Verdana;font-weight:700;}#yiv1823343274 dd.yiv1823343274last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1823343274 
dd.yiv1823343274last p span.yiv1823343274yshortcuts 
{margin-right:0;}#yiv1823343274 div.yiv1823343274attach-table div div a 
{text-decoration:none;}#yiv1823343274 div.yiv1823343274attach-table 
{width:400px;}#yiv1823343274 div.yiv1823343274file-title a, #yiv1823343274 
div.yiv1823343274file-title a:active, #yiv1823343274 
div.yiv1823343274file-title a:hover, #yiv1823343274 div.yiv1823343274file-title 
a:visited {text-decoration:none;}#yiv1823343274 div.yiv1823343274photo-title a, 
#yiv1823343274 div.yiv1823343274photo-title a:active, #yiv1823343274 
div.yiv1823343274photo-title a:hover, #yiv1823343274 
div.yiv1823343274photo-title a:visited {text-decoration:none;}#yiv1823343274 
div#yiv1823343274ygrp-mlmsg #yiv1823343274ygrp-msg p a 
span.yiv1823343274yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1823343274 
.yiv1823343274green {color:#628c2a;}#yiv1823343274 .yiv1823343274MsoNormal 
{margin:0 0 0 0;}#yiv1823343274 o {font-size:0;}#yiv1823343274 
#yiv1823343274photos div {float:left;width:72px;}#yiv1823343274 
#yiv1823343274photos div div {border:1px solid

Bls: Re: [belajar-excel] Vlookup tidak sesuai

2018-01-15 Terurut Topik luddy subiyandoko luddy_subiyand...@yahoo.co.id [belajar-excel] 
Terima kasih sarannya pak abdi
 Kalau apabila yg dicari - 1.64101, kan kalau gak sama gak bisa muncul 
hasilnya, nah itu seperti apa ya pak


Dikirim dari Yahoo Mail di Android

  Pada Sel, 16 Jan 2018 pada 13:20, Abu Abdillaah abuabdillaa...@gmail.com 
[belajar-excel] menulis:    


Dear Pak Luddy
Coba rumus diganti seperti berikut:=VLOOKUP(K340,F330:G346,2,0)


Best regards,
2018-01-16 12:38 GMT+07:00 luddy subiyandoko luddy_subiyand...@yahoo.co.id 
[belajar-excel] :


  
Mohon bantuan master


Ini saya mempunyai kendala terkait rumus vlookup yg tidak sesuai dengan 
hasilnya.
Mohon bantuan petunjuknya


Dikirim dari Yahoo Mail di Android





  #yiv8088326755 #yiv8088326755 -- #yiv8088326755ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8088326755 
#yiv8088326755ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8088326755 
#yiv8088326755ygrp-mkp #yiv8088326755hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8088326755 #yiv8088326755ygrp-mkp #yiv8088326755ads 
{margin-bottom:10px;}#yiv8088326755 #yiv8088326755ygrp-mkp .yiv8088326755ad 
{padding:0 0;}#yiv8088326755 #yiv8088326755ygrp-mkp .yiv8088326755ad p 
{margin:0;}#yiv8088326755 #yiv8088326755ygrp-mkp .yiv8088326755ad a 
{color:#ff;text-decoration:none;}#yiv8088326755 #yiv8088326755ygrp-sponsor 
#yiv8088326755ygrp-lc {font-family:Arial;}#yiv8088326755 
#yiv8088326755ygrp-sponsor #yiv8088326755ygrp-lc #yiv8088326755hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8088326755 
#yiv8088326755ygrp-sponsor #yiv8088326755ygrp-lc .yiv8088326755ad 
{margin-bottom:10px;padding:0 0;}#yiv8088326755 #yiv8088326755actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8088326755 
#yiv8088326755activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8088326755
 #yiv8088326755activity span {font-weight:700;}#yiv8088326755 
#yiv8088326755activity span:first-child 
{text-transform:uppercase;}#yiv8088326755 #yiv8088326755activity span a 
{color:#5085b6;text-decoration:none;}#yiv8088326755 #yiv8088326755activity span 
span {color:#ff7900;}#yiv8088326755 #yiv8088326755activity span 
.yiv8088326755underline {text-decoration:underline;}#yiv8088326755 
.yiv8088326755attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8088326755 .yiv8088326755attach div a 
{text-decoration:none;}#yiv8088326755 .yiv8088326755attach img 
{border:none;padding-right:5px;}#yiv8088326755 .yiv8088326755attach label 
{display:block;margin-bottom:5px;}#yiv8088326755 .yiv8088326755attach label a 
{text-decoration:none;}#yiv8088326755 blockquote {margin:0 0 0 
4px;}#yiv8088326755 ...yiv8088326755bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8088326755 
.yiv8088326755bold a {text-decoration:none;}#yiv8088326755 dd.yiv8088326755last 
p a {font-family:Verdana;font-weight:700;}#yiv8088326755 dd.yiv8088326755last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8088326755 
dd.yiv8088326755last p span.yiv8088326755yshortcuts 
{margin-right:0;}#yiv8088326755 div.yiv8088326755attach-table div div a 
{text-decoration:none;}#yiv8088326755 div.yiv8088326755attach-table 
{width:400px;}#yiv8088326755 div.yiv8088326755file-title a, #yiv8088326755 
div.yiv8088326755file-title a:active, #yiv8088326755 
div.yiv8088326755file-title a:hover, #yiv8088326755 div.yiv8088326755file-title 
a:visited {text-decoration:none;}#yiv8088326755 div.yiv8088326755photo-title a, 
#yiv8088326755 div.yiv8088326755photo-title a:active, #yiv8088326755 
div.yiv8088326755photo-title a:hover, #yiv8088326755 
div.yiv8088326755photo-title a:visited {text-decoration:none;}#yiv8088326755 
div#yiv8088326755ygrp-mlmsg #yiv8088326755ygrp-msg p a 
span.yiv8088326755yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8088326755 
.yiv8088326755green {color:#628c2a;}#yiv8088326755 .yiv8088326755MsoNormal 
{margin:0 0 0 0;}#yiv8088326755 o {font-size:0;}#yiv8088326755 
#yiv8088326755photos div {float:left;width:72px;}#yiv8088326755 
#yiv8088326755photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv8088326755 
#yiv8088326755photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8088326755
 #yiv8088326755reco-category {font-size:77%;}#yiv8088326755 
#yiv8088326755reco-desc {font-size:77%;}#yiv8088326755 .yiv8088326755replbq 
{margin:4px;}#yiv8088326755 #yiv8088326755ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8088326755 #yiv8088326755ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8088326755 
#yiv8088326755ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8088326755 
#yiv8088326755ygrp-mlmsg select, #yiv8088326755 input, #yiv8088326755 textarea 
{font:99% Arial, Helvetica, clean,

Re: [belajar-excel] Vlookup tidak sesuai

2018-01-15 Terurut Topik Abu Abdillaah abuabdillaa...@gmail.com [belajar-excel] 
Dear Pak Luddy

Coba rumus diganti seperti berikut:
=VLOOKUP(K340,F330:G346,2,0)

Best regards,

2018-01-16 12:38 GMT+07:00 luddy subiyandoko luddy_subiyand...@yahoo.co.id
[belajar-excel] :

>
>
> Mohon bantuan master
>
> Ini saya mempunyai kendala terkait rumus vlookup yg tidak sesuai dengan
> hasilnya.
>
> Mohon bantuan petunjuknya
>
> Dikirim dari Yahoo Mail di Android
> 
>
>
>

[belajar-excel] Vlookup tidak sesuai

2018-01-15 Terurut Topik luddy subiyandoko luddy_subiyand...@yahoo.co.id [belajar-excel] 
Mohon bantuan master
Ini saya mempunyai kendala terkait rumus vlookup yg tidak sesuai dengan 
hasilnya.
Mohon bantuan petunjuknya

Dikirim dari Yahoo Mail di Android

Vlookup tidak sesuai.xlsx
Description: MS-Excel 2007 spreadsheet