Terima kasih banyak Mr KId dan Hendrik Karnadi atas Solusinya..

    On Thursday, May 17, 2018, 1:45:30 PM GMT+7, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  

Begini :=IFError( vlookup_ke_sheet1 , vlookup_ke_sheet2 )
Regards,Kid

2018-05-17 9:58 GMT+07:00 adrian piter petcures2...@yahoo.com [belajar-excel] 
<belajar-excel@yahoogroups.com>:

  

Selamat siang.

Sebelumnya saya ucapkan selamat menunaikan ibadah puasa bagi yang 
menjalankannya.
    semoga diberikan kelancaran dan keberkahan.

mohon bantuan solusi para master excel untuk masalah saya
 1. saya mau membuat hasil olah data dengan formula VLOOKUP
 2. Karena data yang akan diolah sangat banyak maka data dibagi ke 2 sheet
yang mau saya tanyakan bagaimanakah formula VLOOKUP nya dengan sumber data yang 
terpisah tersebut?
Terima kasih atas bantuannya.

Salam.




  #yiv0216656831 #yiv0216656831 -- #yiv0216656831ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0216656831 
#yiv0216656831ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0216656831 
#yiv0216656831ygrp-mkp #yiv0216656831hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0216656831 #yiv0216656831ygrp-mkp #yiv0216656831ads 
{margin-bottom:10px;}#yiv0216656831 #yiv0216656831ygrp-mkp .yiv0216656831ad 
{padding:0 0;}#yiv0216656831 #yiv0216656831ygrp-mkp .yiv0216656831ad p 
{margin:0;}#yiv0216656831 #yiv0216656831ygrp-mkp .yiv0216656831ad a 
{color:#0000ff;text-decoration:none;}#yiv0216656831 #yiv0216656831ygrp-sponsor 
#yiv0216656831ygrp-lc {font-family:Arial;}#yiv0216656831 
#yiv0216656831ygrp-sponsor #yiv0216656831ygrp-lc #yiv0216656831hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0216656831 
#yiv0216656831ygrp-sponsor #yiv0216656831ygrp-lc .yiv0216656831ad 
{margin-bottom:10px;padding:0 0;}#yiv0216656831 #yiv0216656831actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0216656831 
#yiv0216656831activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0216656831
 #yiv0216656831activity span {font-weight:700;}#yiv0216656831 
#yiv0216656831activity span:first-child 
{text-transform:uppercase;}#yiv0216656831 #yiv0216656831activity span a 
{color:#5085b6;text-decoration:none;}#yiv0216656831 #yiv0216656831activity span 
span {color:#ff7900;}#yiv0216656831 #yiv0216656831activity span 
.yiv0216656831underline {text-decoration:underline;}#yiv0216656831 
.yiv0216656831attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0216656831 .yiv0216656831attach div a 
{text-decoration:none;}#yiv0216656831 .yiv0216656831attach img 
{border:none;padding-right:5px;}#yiv0216656831 .yiv0216656831attach label 
{display:block;margin-bottom:5px;}#yiv0216656831 .yiv0216656831attach label a 
{text-decoration:none;}#yiv0216656831 blockquote {margin:0 0 0 
4px;}#yiv0216656831 .yiv0216656831bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0216656831 
.yiv0216656831bold a {text-decoration:none;}#yiv0216656831 dd.yiv0216656831last 
p a {font-family:Verdana;font-weight:700;}#yiv0216656831 dd.yiv0216656831last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0216656831 
dd.yiv0216656831last p span.yiv0216656831yshortcuts 
{margin-right:0;}#yiv0216656831 div.yiv0216656831attach-table div div a 
{text-decoration:none;}#yiv0216656831 div.yiv0216656831attach-table 
{width:400px;}#yiv0216656831 div.yiv0216656831file-title a, #yiv0216656831 
div.yiv0216656831file-title a:active, #yiv0216656831 
div.yiv0216656831file-title a:hover, #yiv0216656831 div.yiv0216656831file-title 
a:visited {text-decoration:none;}#yiv0216656831 div.yiv0216656831photo-title a, 
#yiv0216656831 div.yiv0216656831photo-title a:active, #yiv0216656831 
div.yiv0216656831photo-title a:hover, #yiv0216656831 
div.yiv0216656831photo-title a:visited {text-decoration:none;}#yiv0216656831 
div#yiv0216656831ygrp-mlmsg #yiv0216656831ygrp-msg p a 
span.yiv0216656831yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0216656831 
.yiv0216656831green {color:#628c2a;}#yiv0216656831 .yiv0216656831MsoNormal 
{margin:0 0 0 0;}#yiv0216656831 o {font-size:0;}#yiv0216656831 
#yiv0216656831photos div {float:left;width:72px;}#yiv0216656831 
#yiv0216656831photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0216656831 
#yiv0216656831photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0216656831
 #yiv0216656831reco-category {font-size:77%;}#yiv0216656831 
#yiv0216656831reco-desc {font-size:77%;}#yiv0216656831 .yiv0216656831replbq 
{margin:4px;}#yiv0216656831 #yiv0216656831ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0216656831 #yiv0216656831ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0216656831 
#yiv0216656831ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0216656831 
#yiv0216656831ygrp-mlmsg select, #yiv0216656831 input, #yiv0216656831 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0216656831 
#yiv0216656831ygrp-mlmsg pre, #yiv0216656831 code {font:115% 
monospace;}#yiv0216656831 #yiv0216656831ygrp-mlmsg * 
{line-height:1.22em;}#yiv0216656831 #yiv0216656831ygrp-mlmsg #yiv0216656831logo 
{padding-bottom:10px;}#yiv0216656831 #yiv0216656831ygrp-msg p a 
{font-family:Verdana;}#yiv0216656831 #yiv0216656831ygrp-msg 
p#yiv0216656831attach-count span {color:#1E66AE;font-weight:700;}#yiv0216656831 
#yiv0216656831ygrp-reco #yiv0216656831reco-head 
{color:#ff7900;font-weight:700;}#yiv0216656831 #yiv0216656831ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0216656831 #yiv0216656831ygrp-sponsor 
#yiv0216656831ov li a {font-size:130%;text-decoration:none;}#yiv0216656831 
#yiv0216656831ygrp-sponsor #yiv0216656831ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0216656831 
#yiv0216656831ygrp-sponsor #yiv0216656831ov ul {margin:0;padding:0 0 0 
8px;}#yiv0216656831 #yiv0216656831ygrp-text 
{font-family:Georgia;}#yiv0216656831 #yiv0216656831ygrp-text p {margin:0 0 1em 
0;}#yiv0216656831 #yiv0216656831ygrp-text tt {font-size:120%;}#yiv0216656831 
#yiv0216656831ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0216656831   
  • [belajar-excel] T... adrian piter petcures2...@yahoo.com [belajar-excel]
    • Re: [belajar... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
    • Re: [belajar... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • Re: [bel... adrian piter petcures2...@yahoo.com [belajar-excel]

Kirim email ke