Bls: Re: [belajar-excel] Vlookup tidak sesuai
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
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
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,