wa'alaikum salam wr wb
Yth. Hary
kalau sudah di coba pakai vlookup tidak bisa , kira2 apa penyebabnya ?mungkin
saja karena "kata kunci" nya itu homogen (sama) , coba kalau pakai "kata kunci"
pada kolom ID , pasti bisa vlookupnya . hanya saja tidak lagi mengetikkan
area/wilayahnya tetapi mengetikkan ID nya ..
On Wednesday, June 15, 2016 4:31 PM, "haryhary...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Assalammu'alaikum wr
Mohon bantuan para mastah untuk kasus saya ini,Bagaimana memasukkan data2 pada
tabel bila kita ketik "JAKARTA" (lihat attachment)akan muncul sesuai list di
kolom sebelahnyasaya pakai vlookup kok ga bisa yah
wassalammu'alaikum dan terima kasih atas bantuannya #yiv2759260355
#yiv2759260355 -- #yiv2759260355ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2759260355
#yiv2759260355ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2759260355
#yiv2759260355ygrp-mkp #yiv2759260355hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2759260355 #yiv2759260355ygrp-mkp #yiv2759260355ads
{margin-bottom:10px;}#yiv2759260355 #yiv2759260355ygrp-mkp .yiv2759260355ad
{padding:0 0;}#yiv2759260355 #yiv2759260355ygrp-mkp .yiv2759260355ad p
{margin:0;}#yiv2759260355 #yiv2759260355ygrp-mkp .yiv2759260355ad a
{color:#0000ff;text-decoration:none;}#yiv2759260355 #yiv2759260355ygrp-sponsor
#yiv2759260355ygrp-lc {font-family:Arial;}#yiv2759260355
#yiv2759260355ygrp-sponsor #yiv2759260355ygrp-lc #yiv2759260355hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2759260355
#yiv2759260355ygrp-sponsor #yiv2759260355ygrp-lc .yiv2759260355ad
{margin-bottom:10px;padding:0 0;}#yiv2759260355 #yiv2759260355actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2759260355
#yiv2759260355activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2759260355
#yiv2759260355activity span {font-weight:700;}#yiv2759260355
#yiv2759260355activity span:first-child
{text-transform:uppercase;}#yiv2759260355 #yiv2759260355activity span a
{color:#5085b6;text-decoration:none;}#yiv2759260355 #yiv2759260355activity span
span {color:#ff7900;}#yiv2759260355 #yiv2759260355activity span
.yiv2759260355underline {text-decoration:underline;}#yiv2759260355
.yiv2759260355attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2759260355 .yiv2759260355attach div a
{text-decoration:none;}#yiv2759260355 .yiv2759260355attach img
{border:none;padding-right:5px;}#yiv2759260355 .yiv2759260355attach label
{display:block;margin-bottom:5px;}#yiv2759260355 .yiv2759260355attach label a
{text-decoration:none;}#yiv2759260355 blockquote {margin:0 0 0
4px;}#yiv2759260355 .yiv2759260355bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2759260355
.yiv2759260355bold a {text-decoration:none;}#yiv2759260355 dd.yiv2759260355last
p a {font-family:Verdana;font-weight:700;}#yiv2759260355 dd.yiv2759260355last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2759260355
dd.yiv2759260355last p span.yiv2759260355yshortcuts
{margin-right:0;}#yiv2759260355 div.yiv2759260355attach-table div div a
{text-decoration:none;}#yiv2759260355 div.yiv2759260355attach-table
{width:400px;}#yiv2759260355 div.yiv2759260355file-title a, #yiv2759260355
div.yiv2759260355file-title a:active, #yiv2759260355
div.yiv2759260355file-title a:hover, #yiv2759260355 div.yiv2759260355file-title
a:visited {text-decoration:none;}#yiv2759260355 div.yiv2759260355photo-title a,
#yiv2759260355 div.yiv2759260355photo-title a:active, #yiv2759260355
div.yiv2759260355photo-title a:hover, #yiv2759260355
div.yiv2759260355photo-title a:visited {text-decoration:none;}#yiv2759260355
div#yiv2759260355ygrp-mlmsg #yiv2759260355ygrp-msg p a
span.yiv2759260355yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2759260355
.yiv2759260355green {color:#628c2a;}#yiv2759260355 .yiv2759260355MsoNormal
{margin:0 0 0 0;}#yiv2759260355 o {font-size:0;}#yiv2759260355
#yiv2759260355photos div {float:left;width:72px;}#yiv2759260355
#yiv2759260355photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2759260355
#yiv2759260355photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2759260355
#yiv2759260355reco-category {font-size:77%;}#yiv2759260355
#yiv2759260355reco-desc {font-size:77%;}#yiv2759260355 .yiv2759260355replbq
{margin:4px;}#yiv2759260355 #yiv2759260355ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2759260355 #yiv2759260355ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2759260355
#yiv2759260355ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2759260355
#yiv2759260355ygrp-mlmsg select, #yiv2759260355 input, #yiv2759260355 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2759260355
#yiv2759260355ygrp-mlmsg pre, #yiv2759260355 code {font:115%
monospace;}#yiv2759260355 #yiv2759260355ygrp-mlmsg *
{line-height:1.22em;}#yiv2759260355 #yiv2759260355ygrp-mlmsg #yiv2759260355logo
{padding-bottom:10px;}#yiv2759260355 #yiv2759260355ygrp-msg p a
{font-family:Verdana;}#yiv2759260355 #yiv2759260355ygrp-msg
p#yiv2759260355attach-count span {color:#1E66AE;font-weight:700;}#yiv2759260355
#yiv2759260355ygrp-reco #yiv2759260355reco-head
{color:#ff7900;font-weight:700;}#yiv2759260355 #yiv2759260355ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2759260355 #yiv2759260355ygrp-sponsor
#yiv2759260355ov li a {font-size:130%;text-decoration:none;}#yiv2759260355
#yiv2759260355ygrp-sponsor #yiv2759260355ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2759260355
#yiv2759260355ygrp-sponsor #yiv2759260355ov ul {margin:0;padding:0 0 0
8px;}#yiv2759260355 #yiv2759260355ygrp-text
{font-family:Georgia;}#yiv2759260355 #yiv2759260355ygrp-text p {margin:0 0 1em
0;}#yiv2759260355 #yiv2759260355ygrp-text tt {font-size:120%;}#yiv2759260355
#yiv2759260355ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2759260355
