Coba pakai fungsi Indirect...File terlampir. Salam,HK From: "ris ha har1sn.ex...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> To: BeExcel <belajar-excel@yahoogroups.com> Sent: Thursday, 2 April 2015, 10:18 Subject: [belajar-excel] Vlookup dengan banyak sheet [1 Attachment] Assalamu'alaikum. Mohon Maaf sebelumnya jika subjek kurang tepat, karena saya bingung mencari yg pas dengan kasus saya.
Bagaimana cara menampilkan Nama Toko beserta tabel No danKet dengan mengacu Sheet 1,2,3. Misal Data saya rubah menjadi 3, maka akanmenampilkan nama Toko C beserta isi dari variabel No dan Ket. File terlampir Terima kasih banyak atas solusinya.Wassalamu'alaikum #yiv2148540276 #yiv2148540276 -- #yiv2148540276ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2148540276 #yiv2148540276ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2148540276 #yiv2148540276ygrp-mkp #yiv2148540276hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2148540276 #yiv2148540276ygrp-mkp #yiv2148540276ads {margin-bottom:10px;}#yiv2148540276 #yiv2148540276ygrp-mkp .yiv2148540276ad {padding:0 0;}#yiv2148540276 #yiv2148540276ygrp-mkp .yiv2148540276ad p {margin:0;}#yiv2148540276 #yiv2148540276ygrp-mkp .yiv2148540276ad a {color:#0000ff;text-decoration:none;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ygrp-lc {font-family:Arial;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ygrp-lc #yiv2148540276hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ygrp-lc .yiv2148540276ad {margin-bottom:10px;padding:0 0;}#yiv2148540276 #yiv2148540276actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2148540276 #yiv2148540276activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2148540276 #yiv2148540276activity span {font-weight:700;}#yiv2148540276 #yiv2148540276activity span:first-child {text-transform:uppercase;}#yiv2148540276 #yiv2148540276activity span a {color:#5085b6;text-decoration:none;}#yiv2148540276 #yiv2148540276activity span span {color:#ff7900;}#yiv2148540276 #yiv2148540276activity span .yiv2148540276underline {text-decoration:underline;}#yiv2148540276 .yiv2148540276attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2148540276 .yiv2148540276attach div a {text-decoration:none;}#yiv2148540276 .yiv2148540276attach img {border:none;padding-right:5px;}#yiv2148540276 .yiv2148540276attach label {display:block;margin-bottom:5px;}#yiv2148540276 .yiv2148540276attach label a {text-decoration:none;}#yiv2148540276 blockquote {margin:0 0 0 4px;}#yiv2148540276 .yiv2148540276bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2148540276 .yiv2148540276bold a {text-decoration:none;}#yiv2148540276 dd.yiv2148540276last p a {font-family:Verdana;font-weight:700;}#yiv2148540276 dd.yiv2148540276last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2148540276 dd.yiv2148540276last p span.yiv2148540276yshortcuts {margin-right:0;}#yiv2148540276 div.yiv2148540276attach-table div div a {text-decoration:none;}#yiv2148540276 div.yiv2148540276attach-table {width:400px;}#yiv2148540276 div.yiv2148540276file-title a, #yiv2148540276 div.yiv2148540276file-title a:active, #yiv2148540276 div.yiv2148540276file-title a:hover, #yiv2148540276 div.yiv2148540276file-title a:visited {text-decoration:none;}#yiv2148540276 div.yiv2148540276photo-title a, #yiv2148540276 div.yiv2148540276photo-title a:active, #yiv2148540276 div.yiv2148540276photo-title a:hover, #yiv2148540276 div.yiv2148540276photo-title a:visited {text-decoration:none;}#yiv2148540276 div#yiv2148540276ygrp-mlmsg #yiv2148540276ygrp-msg p a span.yiv2148540276yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2148540276 .yiv2148540276green {color:#628c2a;}#yiv2148540276 .yiv2148540276MsoNormal {margin:0 0 0 0;}#yiv2148540276 o {font-size:0;}#yiv2148540276 #yiv2148540276photos div {float:left;width:72px;}#yiv2148540276 #yiv2148540276photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2148540276 #yiv2148540276photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2148540276 #yiv2148540276reco-category {font-size:77%;}#yiv2148540276 #yiv2148540276reco-desc {font-size:77%;}#yiv2148540276 .yiv2148540276replbq {margin:4px;}#yiv2148540276 #yiv2148540276ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2148540276 #yiv2148540276ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2148540276 #yiv2148540276ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2148540276 #yiv2148540276ygrp-mlmsg select, #yiv2148540276 input, #yiv2148540276 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2148540276 #yiv2148540276ygrp-mlmsg pre, #yiv2148540276 code {font:115% monospace;}#yiv2148540276 #yiv2148540276ygrp-mlmsg * {line-height:1.22em;}#yiv2148540276 #yiv2148540276ygrp-mlmsg #yiv2148540276logo {padding-bottom:10px;}#yiv2148540276 #yiv2148540276ygrp-msg p a {font-family:Verdana;}#yiv2148540276 #yiv2148540276ygrp-msg p#yiv2148540276attach-count span {color:#1E66AE;font-weight:700;}#yiv2148540276 #yiv2148540276ygrp-reco #yiv2148540276reco-head {color:#ff7900;font-weight:700;}#yiv2148540276 #yiv2148540276ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ov li a {font-size:130%;text-decoration:none;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2148540276 #yiv2148540276ygrp-sponsor #yiv2148540276ov ul {margin:0;padding:0 0 0 8px;}#yiv2148540276 #yiv2148540276ygrp-text {font-family:Georgia;}#yiv2148540276 #yiv2148540276ygrp-text p {margin:0 0 1em 0;}#yiv2148540276 #yiv2148540276ygrp-text tt {font-size:120%;}#yiv2148540276 #yiv2148540276ygrp-vital ul li:last-child {border-right:none !important;}#yiv2148540276
re-VLOOKUP dengan banyak Sheet.xlsx
Description: MS-Excel 2007 spreadsheet