Siang,
Terima kasih atas sarannya pak, kalau boleh saya tambahkan ada beberapa kasus
kode barang yang ingin dicari ada di depan atau bahkan di belakang. tidak
selamanya ada di tengah, mohon bantuannya.
ThanksTannu
On Monday, March 2, 2015 3:56 PM, "uharyanto uharya...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Coba buat seperti ini : =SUMIF($B$4:$B$13,"*"&E3&"*",$C$4:$C$13)
On 27/02/2015 11:43 AM, tannuwiwo...@yahoo.com [belajar-excel] wrote:
Siang,
Mohon bantuan para master atas contoh kasus seperti terlampir, bagaimana
menggunakan rumus vlookup tapi hanya mengetahui sebagian character saja.
Thanks
Tannu
#yiv5386698566 #yiv5386698566 -- #yiv5386698566ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5386698566
#yiv5386698566ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5386698566
#yiv5386698566ygrp-mkp #yiv5386698566hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5386698566 #yiv5386698566ygrp-mkp #yiv5386698566ads
{margin-bottom:10px;}#yiv5386698566 #yiv5386698566ygrp-mkp .yiv5386698566ad
{padding:0 0;}#yiv5386698566 #yiv5386698566ygrp-mkp .yiv5386698566ad p
{margin:0;}#yiv5386698566 #yiv5386698566ygrp-mkp .yiv5386698566ad a
{color:#0000ff;text-decoration:none;}#yiv5386698566 #yiv5386698566ygrp-sponsor
#yiv5386698566ygrp-lc {font-family:Arial;}#yiv5386698566
#yiv5386698566ygrp-sponsor #yiv5386698566ygrp-lc #yiv5386698566hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5386698566
#yiv5386698566ygrp-sponsor #yiv5386698566ygrp-lc .yiv5386698566ad
{margin-bottom:10px;padding:0 0;}#yiv5386698566 #yiv5386698566actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5386698566
#yiv5386698566activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5386698566
#yiv5386698566activity span {font-weight:700;}#yiv5386698566
#yiv5386698566activity span:first-child
{text-transform:uppercase;}#yiv5386698566 #yiv5386698566activity span a
{color:#5085b6;text-decoration:none;}#yiv5386698566 #yiv5386698566activity span
span {color:#ff7900;}#yiv5386698566 #yiv5386698566activity span
.yiv5386698566underline {text-decoration:underline;}#yiv5386698566
.yiv5386698566attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5386698566 .yiv5386698566attach div a
{text-decoration:none;}#yiv5386698566 .yiv5386698566attach img
{border:none;padding-right:5px;}#yiv5386698566 .yiv5386698566attach label
{display:block;margin-bottom:5px;}#yiv5386698566 .yiv5386698566attach label a
{text-decoration:none;}#yiv5386698566 blockquote {margin:0 0 0
4px;}#yiv5386698566 .yiv5386698566bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5386698566
.yiv5386698566bold a {text-decoration:none;}#yiv5386698566 dd.yiv5386698566last
p a {font-family:Verdana;font-weight:700;}#yiv5386698566 dd.yiv5386698566last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5386698566
dd.yiv5386698566last p span.yiv5386698566yshortcuts
{margin-right:0;}#yiv5386698566 div.yiv5386698566attach-table div div a
{text-decoration:none;}#yiv5386698566 div.yiv5386698566attach-table
{width:400px;}#yiv5386698566 div.yiv5386698566file-title a, #yiv5386698566
div.yiv5386698566file-title a:active, #yiv5386698566
div.yiv5386698566file-title a:hover, #yiv5386698566 div.yiv5386698566file-title
a:visited {text-decoration:none;}#yiv5386698566 div.yiv5386698566photo-title a,
#yiv5386698566 div.yiv5386698566photo-title a:active, #yiv5386698566
div.yiv5386698566photo-title a:hover, #yiv5386698566
div.yiv5386698566photo-title a:visited {text-decoration:none;}#yiv5386698566
div#yiv5386698566ygrp-mlmsg #yiv5386698566ygrp-msg p a
span.yiv5386698566yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5386698566
.yiv5386698566green {color:#628c2a;}#yiv5386698566 .yiv5386698566MsoNormal
{margin:0 0 0 0;}#yiv5386698566 o {font-size:0;}#yiv5386698566
#yiv5386698566photos div {float:left;width:72px;}#yiv5386698566
#yiv5386698566photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5386698566
#yiv5386698566photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5386698566
#yiv5386698566reco-category {font-size:77%;}#yiv5386698566
#yiv5386698566reco-desc {font-size:77%;}#yiv5386698566 .yiv5386698566replbq
{margin:4px;}#yiv5386698566 #yiv5386698566ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5386698566 #yiv5386698566ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5386698566
#yiv5386698566ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5386698566
#yiv5386698566ygrp-mlmsg select, #yiv5386698566 input, #yiv5386698566 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5386698566
#yiv5386698566ygrp-mlmsg pre, #yiv5386698566 code {font:115%
monospace;}#yiv5386698566 #yiv5386698566ygrp-mlmsg *
{line-height:1.22em;}#yiv5386698566 #yiv5386698566ygrp-mlmsg #yiv5386698566logo
{padding-bottom:10px;}#yiv5386698566 #yiv5386698566ygrp-msg p a
{font-family:Verdana;}#yiv5386698566 #yiv5386698566ygrp-msg
p#yiv5386698566attach-count span {color:#1E66AE;font-weight:700;}#yiv5386698566
#yiv5386698566ygrp-reco #yiv5386698566reco-head
{color:#ff7900;font-weight:700;}#yiv5386698566 #yiv5386698566ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5386698566 #yiv5386698566ygrp-sponsor
#yiv5386698566ov li a {font-size:130%;text-decoration:none;}#yiv5386698566
#yiv5386698566ygrp-sponsor #yiv5386698566ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5386698566
#yiv5386698566ygrp-sponsor #yiv5386698566ov ul {margin:0;padding:0 0 0
8px;}#yiv5386698566 #yiv5386698566ygrp-text
{font-family:Georgia;}#yiv5386698566 #yiv5386698566ygrp-text p {margin:0 0 1em
0;}#yiv5386698566 #yiv5386698566ygrp-text tt {font-size:120%;}#yiv5386698566
#yiv5386698566ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5386698566
