kok itu sama-sama SHT tapi angka konfersinya berbeda...???jadi apa kriterianya
untuk mengambil data konfersi...?klo diliat itu vlookupnya mengacu pada ID,
apakah akan di konfersi berdasarkan ID value...?bila memang demikian ya harus
di jabarkan berapa nilai untuk masing -masing konfersi. br,
odong nando
Pada Rabu, 2 Maret 2016 15:32, "Lukman Hakim [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Masters,
Ane punya kasus dimana ane ingin mengkonversi secara otomatis seperti berikut,
| Awal | | | | | |
| ID | Qty | Unit | konversi | Qty (in Kg) | |
| 1000464 | 29,631.36 | KG | 1 | 29631.36 | . |
| 1000464 | 4,938.56 | KG | 1 | 4938.56 | |
| 1000445 | 118,800 | SHT | 0.123456 | 14666.5728 | |
| 1000791 | 279,000 | SHT | 0.654321 | 182555.559 | |
| | | | | | |
| Yang diinginkan | | | | |
| ID | Qty | Unit | Qty (in Kg) | | |
| 1000464 | 29,631.36 | KG | | | |
| 1000464 | 4,938.56 | KG | | | |
| 1000445 | 118,800 | SHT | | | |
| 1000791 | 279,000 | SHT | | | |
| | | | | | |
| | | | | | |
| | | | | | |
Jadi kolom "qty in kg" nya terisi otomatis dengan hasil vlookup kalau SHT dan
di kali 1 kalau KG.
Atas bantuannya ane ucapkan terimakasih,
NB: data terlampir
Salam,
Lukman #yiv1479899828 #yiv1479899828 -- #yiv1479899828ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1479899828
#yiv1479899828ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1479899828
#yiv1479899828ygrp-mkp #yiv1479899828hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1479899828 #yiv1479899828ygrp-mkp #yiv1479899828ads
{margin-bottom:10px;}#yiv1479899828 #yiv1479899828ygrp-mkp .yiv1479899828ad
{padding:0 0;}#yiv1479899828 #yiv1479899828ygrp-mkp .yiv1479899828ad p
{margin:0;}#yiv1479899828 #yiv1479899828ygrp-mkp .yiv1479899828ad a
{color:#0000ff;text-decoration:none;}#yiv1479899828 #yiv1479899828ygrp-sponsor
#yiv1479899828ygrp-lc {font-family:Arial;}#yiv1479899828
#yiv1479899828ygrp-sponsor #yiv1479899828ygrp-lc #yiv1479899828hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1479899828
#yiv1479899828ygrp-sponsor #yiv1479899828ygrp-lc .yiv1479899828ad
{margin-bottom:10px;padding:0 0;}#yiv1479899828 #yiv1479899828actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1479899828
#yiv1479899828activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1479899828
#yiv1479899828activity span {font-weight:700;}#yiv1479899828
#yiv1479899828activity span:first-child
{text-transform:uppercase;}#yiv1479899828 #yiv1479899828activity span a
{color:#5085b6;text-decoration:none;}#yiv1479899828 #yiv1479899828activity span
span {color:#ff7900;}#yiv1479899828 #yiv1479899828activity span
.yiv1479899828underline {text-decoration:underline;}#yiv1479899828
.yiv1479899828attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1479899828 .yiv1479899828attach div a
{text-decoration:none;}#yiv1479899828 .yiv1479899828attach img
{border:none;padding-right:5px;}#yiv1479899828 .yiv1479899828attach label
{display:block;margin-bottom:5px;}#yiv1479899828 .yiv1479899828attach label a
{text-decoration:none;}#yiv1479899828 blockquote {margin:0 0 0
4px;}#yiv1479899828 .yiv1479899828bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1479899828
.yiv1479899828bold a {text-decoration:none;}#yiv1479899828 dd.yiv1479899828last
p a {font-family:Verdana;font-weight:700;}#yiv1479899828 dd.yiv1479899828last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1479899828
dd.yiv1479899828last p span.yiv1479899828yshortcuts
{margin-right:0;}#yiv1479899828 div.yiv1479899828attach-table div div a
{text-decoration:none;}#yiv1479899828 div.yiv1479899828attach-table
{width:400px;}#yiv1479899828 div.yiv1479899828file-title a, #yiv1479899828
div.yiv1479899828file-title a:active, #yiv1479899828
div.yiv1479899828file-title a:hover, #yiv1479899828 div.yiv1479899828file-title
a:visited {text-decoration:none;}#yiv1479899828 div.yiv1479899828photo-title a,
#yiv1479899828 div.yiv1479899828photo-title a:active, #yiv1479899828
div.yiv1479899828photo-title a:hover, #yiv1479899828
div.yiv1479899828photo-title a:visited {text-decoration:none;}#yiv1479899828
div#yiv1479899828ygrp-mlmsg #yiv1479899828ygrp-msg p a
span.yiv1479899828yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1479899828
.yiv1479899828green {color:#628c2a;}#yiv1479899828 .yiv1479899828MsoNormal
{margin:0 0 0 0;}#yiv1479899828 o {font-size:0;}#yiv1479899828
#yiv1479899828photos div {float:left;width:72px;}#yiv1479899828
#yiv1479899828photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1479899828
#yiv1479899828photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1479899828
#yiv1479899828reco-category {font-size:77%;}#yiv1479899828
#yiv1479899828reco-desc {font-size:77%;}#yiv1479899828 .yiv1479899828replbq
{margin:4px;}#yiv1479899828 #yiv1479899828ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1479899828 #yiv1479899828ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1479899828
#yiv1479899828ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1479899828
#yiv1479899828ygrp-mlmsg select, #yiv1479899828 input, #yiv1479899828 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1479899828
#yiv1479899828ygrp-mlmsg pre, #yiv1479899828 code {font:115%
monospace;}#yiv1479899828 #yiv1479899828ygrp-mlmsg *
{line-height:1.22em;}#yiv1479899828 #yiv1479899828ygrp-mlmsg #yiv1479899828logo
{padding-bottom:10px;}#yiv1479899828 #yiv1479899828ygrp-msg p a
{font-family:Verdana;}#yiv1479899828 #yiv1479899828ygrp-msg
p#yiv1479899828attach-count span {color:#1E66AE;font-weight:700;}#yiv1479899828
#yiv1479899828ygrp-reco #yiv1479899828reco-head
{color:#ff7900;font-weight:700;}#yiv1479899828 #yiv1479899828ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1479899828 #yiv1479899828ygrp-sponsor
#yiv1479899828ov li a {font-size:130%;text-decoration:none;}#yiv1479899828
#yiv1479899828ygrp-sponsor #yiv1479899828ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1479899828
#yiv1479899828ygrp-sponsor #yiv1479899828ov ul {margin:0;padding:0 0 0
8px;}#yiv1479899828 #yiv1479899828ygrp-text
{font-family:Georgia;}#yiv1479899828 #yiv1479899828ygrp-text p {margin:0 0 1em
0;}#yiv1479899828 #yiv1479899828ygrp-text tt {font-size:120%;}#yiv1479899828
#yiv1479899828ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1479899828
