Hai..
Anda bisa menggunakan PivotTable atau VBA..
TerimaKasih.
Pada Rabu, 15 Juni 2016 16:32, "[email protected] [belajar-excel]"
<[email protected]> menulis:
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 #yiv4186681573
#yiv4186681573 -- #yiv4186681573ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4186681573
#yiv4186681573ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4186681573
#yiv4186681573ygrp-mkp #yiv4186681573hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4186681573 #yiv4186681573ygrp-mkp #yiv4186681573ads
{margin-bottom:10px;}#yiv4186681573 #yiv4186681573ygrp-mkp .yiv4186681573ad
{padding:0 0;}#yiv4186681573 #yiv4186681573ygrp-mkp .yiv4186681573ad p
{margin:0;}#yiv4186681573 #yiv4186681573ygrp-mkp .yiv4186681573ad a
{color:#0000ff;text-decoration:none;}#yiv4186681573 #yiv4186681573ygrp-sponsor
#yiv4186681573ygrp-lc {font-family:Arial;}#yiv4186681573
#yiv4186681573ygrp-sponsor #yiv4186681573ygrp-lc #yiv4186681573hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4186681573
#yiv4186681573ygrp-sponsor #yiv4186681573ygrp-lc .yiv4186681573ad
{margin-bottom:10px;padding:0 0;}#yiv4186681573 #yiv4186681573actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4186681573
#yiv4186681573activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4186681573
#yiv4186681573activity span {font-weight:700;}#yiv4186681573
#yiv4186681573activity span:first-child
{text-transform:uppercase;}#yiv4186681573 #yiv4186681573activity span a
{color:#5085b6;text-decoration:none;}#yiv4186681573 #yiv4186681573activity span
span {color:#ff7900;}#yiv4186681573 #yiv4186681573activity span
.yiv4186681573underline {text-decoration:underline;}#yiv4186681573
.yiv4186681573attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4186681573 .yiv4186681573attach div a
{text-decoration:none;}#yiv4186681573 .yiv4186681573attach img
{border:none;padding-right:5px;}#yiv4186681573 .yiv4186681573attach label
{display:block;margin-bottom:5px;}#yiv4186681573 .yiv4186681573attach label a
{text-decoration:none;}#yiv4186681573 blockquote {margin:0 0 0
4px;}#yiv4186681573 .yiv4186681573bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4186681573
.yiv4186681573bold a {text-decoration:none;}#yiv4186681573 dd.yiv4186681573last
p a {font-family:Verdana;font-weight:700;}#yiv4186681573 dd.yiv4186681573last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4186681573
dd.yiv4186681573last p span.yiv4186681573yshortcuts
{margin-right:0;}#yiv4186681573 div.yiv4186681573attach-table div div a
{text-decoration:none;}#yiv4186681573 div.yiv4186681573attach-table
{width:400px;}#yiv4186681573 div.yiv4186681573file-title a, #yiv4186681573
div.yiv4186681573file-title a:active, #yiv4186681573
div.yiv4186681573file-title a:hover, #yiv4186681573 div.yiv4186681573file-title
a:visited {text-decoration:none;}#yiv4186681573 div.yiv4186681573photo-title a,
#yiv4186681573 div.yiv4186681573photo-title a:active, #yiv4186681573
div.yiv4186681573photo-title a:hover, #yiv4186681573
div.yiv4186681573photo-title a:visited {text-decoration:none;}#yiv4186681573
div#yiv4186681573ygrp-mlmsg #yiv4186681573ygrp-msg p a
span.yiv4186681573yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4186681573
.yiv4186681573green {color:#628c2a;}#yiv4186681573 .yiv4186681573MsoNormal
{margin:0 0 0 0;}#yiv4186681573 o {font-size:0;}#yiv4186681573
#yiv4186681573photos div {float:left;width:72px;}#yiv4186681573
#yiv4186681573photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4186681573
#yiv4186681573photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4186681573
#yiv4186681573reco-category {font-size:77%;}#yiv4186681573
#yiv4186681573reco-desc {font-size:77%;}#yiv4186681573 .yiv4186681573replbq
{margin:4px;}#yiv4186681573 #yiv4186681573ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4186681573 #yiv4186681573ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4186681573
#yiv4186681573ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4186681573
#yiv4186681573ygrp-mlmsg select, #yiv4186681573 input, #yiv4186681573 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4186681573
#yiv4186681573ygrp-mlmsg pre, #yiv4186681573 code {font:115%
monospace;}#yiv4186681573 #yiv4186681573ygrp-mlmsg *
{line-height:1.22em;}#yiv4186681573 #yiv4186681573ygrp-mlmsg #yiv4186681573logo
{padding-bottom:10px;}#yiv4186681573 #yiv4186681573ygrp-msg p a
{font-family:Verdana;}#yiv4186681573 #yiv4186681573ygrp-msg
p#yiv4186681573attach-count span {color:#1E66AE;font-weight:700;}#yiv4186681573
#yiv4186681573ygrp-reco #yiv4186681573reco-head
{color:#ff7900;font-weight:700;}#yiv4186681573 #yiv4186681573ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4186681573 #yiv4186681573ygrp-sponsor
#yiv4186681573ov li a {font-size:130%;text-decoration:none;}#yiv4186681573
#yiv4186681573ygrp-sponsor #yiv4186681573ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4186681573
#yiv4186681573ygrp-sponsor #yiv4186681573ov ul {margin:0;padding:0 0 0
8px;}#yiv4186681573 #yiv4186681573ygrp-text
{font-family:Georgia;}#yiv4186681573 #yiv4186681573ygrp-text p {margin:0 0 1em
0;}#yiv4186681573 #yiv4186681573ygrp-text tt {font-size:120%;}#yiv4186681573
#yiv4186681573ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4186681573
