Sebelumnya terimakasih atas solusinya Tapi saat tidak selamanya kalimatnya kondisi yg ke-2 slalu 2 char d belakang dan tidak selamanya kalimatnya kondisinya yg ke-1 slalu 2 char di depan. Kira-kira bisa tidak yang mencari dari kalimat berdasarkan 2 kondisi tidak berdasarkan 2 char di depan dan 2 char di belakang.
Terimakasih sebelumnya Ano kumo no you ni jiyuu ni...... --- On Sun, 4/24/11, bagus <[email protected]> wrote: From: bagus <[email protected]> Subject: Re: ]] XL-mania [[ Mencari kode Berdasarkan master list To: [email protected] Date: Sunday, April 24, 2011, 8:01 PM Dear hantu V; Misalkan master code ada di colom A Coba pakai formula berikut =left(A1,2)&right(A1,2) Semoga seperti yg diharapkan Sent from my Taxiphone® ----- Original Message ----- From: Ghost-V To: [email protected] Sent: Sunday, April 24, 2011 1:59 PM Subject: ]] XL-mania [[ Mencari kode Berdasarkan master list Dear Xl- Mania Saya ada problem berat nih.. Untuk mencari kode berdasarkan kalimat yang ada. Kode itu berdasarkan Master kode yang sudah ada. Nah yang buat saya bingung mencari kata2 untuk masing-kondisi yang berbeda-beda seperti penggunaan Vlookup. Untuk lebih detailnya coba mohon d lihat file question.xls yang saya sertakan. Mohon solusinya kira2 bagaimana ya pake sekedar rumus biasa atau harus macro. Terimakasih sebelumnya.. #yiv486907534 #yiv486907534ygrp-mkp { BORDER-RIGHT:#d8d8d8 1px solid;PADDING-RIGHT:10px;BORDER-TOP:#d8d8d8 1px solid;PADDING-LEFT:10px;PADDING-BOTTOM:0px;MARGIN:10px 0px;BORDER-LEFT:#d8d8d8 1px solid;PADDING-TOP:0px;BORDER-BOTTOM:#d8d8d8 1px solid;FONT-FAMILY:Arial;} #yiv486907534 #yiv486907534ygrp-mkp HR { BORDER-RIGHT:#d8d8d8 1px solid;BORDER-TOP:#d8d8d8 1px solid;BORDER-LEFT:#d8d8d8 1px solid;BORDER-BOTTOM:#d8d8d8 1px solid;} #yiv486907534 #yiv486907534ygrp-mkp #yiv486907534hd { FONT-WEIGHT:700;FONT-SIZE:85%;MARGIN:10px 0px;COLOR:#628c2a;LINE-HEIGHT:122%;} #yiv486907534 #yiv486907534ygrp-mkp #yiv486907534ads { MARGIN-BOTTOM:10px;} #yiv486907534 #yiv486907534ygrp-mkp .yiv486907534ad { PADDING-RIGHT:0px;PADDING-LEFT:0px;PADDING-BOTTOM:0px;PADDING-TOP:0px;} #yiv486907534 #yiv486907534ygrp-mkp .yiv486907534ad P { MARGIN:0px;} #yiv486907534 #yiv486907534ygrp-mkp .yiv486907534ad A { COLOR:#0000ff;TEXT-DECORATION:none;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ygrp-lc { FONT-FAMILY:Arial;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ygrp-lc #yiv486907534hd { FONT-WEIGHT:700;FONT-SIZE:78%;MARGIN:10px 0px;LINE-HEIGHT:122%;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ygrp-lc .yiv486907534ad { PADDING-RIGHT:0px;PADDING-LEFT:0px;MARGIN-BOTTOM:10px;PADDING-BOTTOM:0px;PADDING-TOP:0px;} #yiv486907534 A { COLOR:#1e66ae;} #yiv486907534 #yiv486907534actions { PADDING-RIGHT:0px;PADDING-LEFT:0px;FONT-SIZE:11px;PADDING-BOTTOM:10px;PADDING-TOP:10px;FONT-FAMILY:Verdana;} #yiv486907534 #yiv486907534activity { PADDING-RIGHT:10px;PADDING-LEFT:10px;FONT-SIZE:10px;FLOAT:left;PADDING-BOTTOM:10px;PADDING-TOP:10px;FONT-FAMILY:Verdana;BACKGROUND-COLOR:#e0ecee;} #yiv486907534 #yiv486907534activity SPAN { FONT-WEIGHT:700;} #yiv486907534 #yiv486907534activity SPAN:unknown { TEXT-TRANSFORM:uppercase;} #yiv486907534 #yiv486907534activity SPAN A { COLOR:#5085b6;TEXT-DECORATION:none;} #yiv486907534 #yiv486907534activity SPAN SPAN { COLOR:#ff7900;} #yiv486907534 #yiv486907534activity SPAN .yiv486907534underline { TEXT-DECORATION:underline;} #yiv486907534 .yiv486907534attach { CLEAR:both;PADDING-RIGHT:0px;PADDING-LEFT:0px;FONT-SIZE:12px;PADDING-BOTTOM:10px;WIDTH:400px;PADDING-TOP:10px;FONT-FAMILY:Arial;} #yiv486907534 .yiv486907534attach DIV A { TEXT-DECORATION:none;} #yiv486907534 .yiv486907534attach IMG { PADDING-RIGHT:5px;BORDER-TOP-STYLE:none;BORDER-RIGHT-STYLE:none;BORDER-LEFT-STYLE:none;BORDER-BOTTOM-STYLE:none;} #yiv486907534 .yiv486907534attach LABEL { DISPLAY:block;MARGIN-BOTTOM:5px;} #yiv486907534 .yiv486907534attach LABEL A { TEXT-DECORATION:none;} #yiv486907534 BLOCKQUOTE { MARGIN:0px 0px 0px 4px;} #yiv486907534 .yiv486907534bold { FONT-WEIGHT:700;FONT-SIZE:13px;FONT-FAMILY:Arial;} #yiv486907534 .yiv486907534bold A { TEXT-DECORATION:none;} #yiv486907534 DD.yiv486907534last P A { FONT-WEIGHT:700;FONT-FAMILY:Verdana;} #yiv486907534 DD.yiv486907534last P SPAN { FONT-WEIGHT:700;MARGIN-RIGHT:10px;FONT-FAMILY:Verdana;} #yiv486907534 DD.yiv486907534last P SPAN.yiv486907534yshortcuts { MARGIN-RIGHT:0px;} #yiv486907534 DIV.yiv486907534attach-table DIV DIV A { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534attach-table { WIDTH:400px;} #yiv486907534 DIV.yiv486907534file-title A { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534file-title A:active { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534file-title A:hover { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534file-title A:visited { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534photo-title A { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534photo-title A:active { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534photo-title A:hover { TEXT-DECORATION:none;} #yiv486907534 DIV.yiv486907534photo-title A:visited { TEXT-DECORATION:none;} #yiv486907534 DIV#yiv486907534ygrp-mlmsg #yiv486907534ygrp-msg P A SPAN.yiv486907534yshortcuts { FONT-WEIGHT:normal;FONT-SIZE:10px;FONT-FAMILY:Verdana;} #yiv486907534 .yiv486907534green { COLOR:#628c2a;} #yiv486907534 .yiv486907534MsoNormal { MARGIN:0px;} #yiv486907534 o { FONT-SIZE:0px;} #yiv486907534 #yiv486907534photos DIV { FLOAT:left;WIDTH:72px;} #yiv486907534 #yiv486907534photos DIV DIV { BORDER-RIGHT:#666666 1px solid;BORDER-TOP:#666666 1px solid;OVERFLOW:hidden;BORDER-LEFT:#666666 1px solid;WIDTH:62px;BORDER-BOTTOM:#666666 1px solid;HEIGHT:62px;} #yiv486907534 #yiv486907534photos DIV LABEL { FONT-SIZE:10px;OVERFLOW:hidden;WIDTH:64px;COLOR:#666666;WHITE-SPACE:nowrap;TEXT-ALIGN:center;} #yiv486907534 #yiv486907534reco-category { FONT-SIZE:77%;} #yiv486907534 #yiv486907534reco-desc { FONT-SIZE:77%;} #yiv486907534 .yiv486907534replbq { MARGIN:4px;} #yiv486907534 #yiv486907534ygrp-actbar DIV A:unknown { PADDING-RIGHT:5px;MARGIN-RIGHT:2px;} #yiv486907534 #yiv486907534ygrp-mlmsg { FONT-SIZE:small;FONT-FAMILY:Arial, helvetica, clean, sans-serif;} #yiv486907534 #yiv486907534ygrp-mlmsg TABLE { } #yiv486907534 #yiv486907534ygrp-mlmsg SELECT { FONT:99% Arial, Helvetica, clean, sans-serif;} #yiv486907534 INPUT { FONT:99% Arial, Helvetica, clean, sans-serif;} #yiv486907534 TEXTAREA { FONT:99% Arial, Helvetica, clean, sans-serif;} #yiv486907534 #yiv486907534ygrp-mlmsg PRE { FONT:100% monospace;} #yiv486907534 CODE { FONT:100% monospace;} #yiv486907534 #yiv486907534ygrp-mlmsg { LINE-HEIGHT:1.22em;} #yiv486907534 #yiv486907534ygrp-mlmsg #yiv486907534logo { PADDING-BOTTOM:10px;} #yiv486907534 #yiv486907534ygrp-mlmsg A { COLOR:#1e66ae;} #yiv486907534 #yiv486907534ygrp-msg P A { FONT-FAMILY:Verdana;} #yiv486907534 #yiv486907534ygrp-msg P#yiv486907534attach-count SPAN { FONT-WEIGHT:700;COLOR:#1e66ae;} #yiv486907534 #yiv486907534ygrp-reco #yiv486907534reco-head { FONT-WEIGHT:700;COLOR:#ff7900;} #yiv486907534 #yiv486907534ygrp-reco { PADDING-RIGHT:0px;PADDING-LEFT:0px;MARGIN-BOTTOM:20px;PADDING-BOTTOM:0px;PADDING-TOP:0px;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ov LI A { FONT-SIZE:130%;TEXT-DECORATION:none;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ov LI { PADDING-RIGHT:0px;PADDING-LEFT:0px;FONT-SIZE:77%;PADDING-BOTTOM:6px;PADDING-TOP:6px;LIST-STYLE-TYPE:square;} #yiv486907534 #yiv486907534ygrp-sponsor #yiv486907534ov UL { PADDING-RIGHT:0px;PADDING-LEFT:8px;PADDING-BOTTOM:0px;MARGIN:0px;PADDING-TOP:0px;} #yiv486907534 #yiv486907534ygrp-text { FONT-FAMILY:Georgia;} #yiv486907534 #yiv486907534ygrp-text P { MARGIN:0px 0px 1em;} #yiv486907534 #yiv486907534ygrp-text TT { FONT-SIZE:120%;} #yiv486907534 #yiv486907534ygrp-vital UL LI:unknown { }
