Terima kasih, atas masukkan dan respon para master semua. Alhamdulillah masalah
terpecahkan.
SalamHaris
On Tuesday, October 7, 2014 5:53 PM, "ris ha har1sn.ex...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Berikut saya kirimkan kembali file contoh dengan data lebih dinamis.
Terima kasih
On Tuesday, October 7, 2014 5:45 PM, ris ha <har1sn.ex...@yahoo.com> wrote:
terima kasih sebelumnya. Masih belum bisa pak, hasilnya False.
Dari kasus saya yang menjadi acuan adalah bulan dan tanggal, sehingga tatkala
bulan berganti oktober (10) maka secara otomatis dia akan mencari pada kolom
oktober dan mencocokan tanggal pada kolom oktober tersebut.
On Tuesday, October 7, 2014 3:58 PM, "Nang Agus nanga...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Walaikumsalam warahmatullah.
Mas Haris, Coba gunakan formula:
=INDEX(Pjs!R2:R10;MATCH(DAY(OutPut!B2);Pjs!Q2:Q10;0))
Jangan lupa mengubah ; menjadi , apabila komputer anda m,enggunakan regional
setting english atau usa.
Wasalam
KenangAgus
2014-10-07 14:51 GMT+07:00 ris ha har1sn.ex...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
Assalamu'alaikum para master semua
Mohon bantuannya atas kasus saya, sebenarnya saya bingung memberi subject pada
email ini terkait kasus saya, sehingga saya beri nama Vlookup Kanan Kiri, mohon
maaf jika ternyata kurang tepat subjectnya.
Kasus yang saya hadapi adalah menampilkan nama pejabat (di Sheet OutPut) dengan
mengacu pada tanggal dan bulan (sept adl bulan ke 9) di sheet Pjs dan sheet
Data. File Terlampir.
Sukses selalu untuk para master semua. Terima kasih
Salam
Haris
#yiv3094694492 #yiv3094694492 -- #yiv3094694492ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3094694492
#yiv3094694492ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3094694492
#yiv3094694492ygrp-mkp #yiv3094694492hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3094694492 #yiv3094694492ygrp-mkp #yiv3094694492ads
{margin-bottom:10px;}#yiv3094694492 #yiv3094694492ygrp-mkp .yiv3094694492ad
{padding:0 0;}#yiv3094694492 #yiv3094694492ygrp-mkp .yiv3094694492ad p
{margin:0;}#yiv3094694492 #yiv3094694492ygrp-mkp .yiv3094694492ad a
{color:#0000ff;text-decoration:none;}#yiv3094694492 #yiv3094694492ygrp-sponsor
#yiv3094694492ygrp-lc {font-family:Arial;}#yiv3094694492
#yiv3094694492ygrp-sponsor #yiv3094694492ygrp-lc #yiv3094694492hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3094694492
#yiv3094694492ygrp-sponsor #yiv3094694492ygrp-lc .yiv3094694492ad
{margin-bottom:10px;padding:0 0;}#yiv3094694492 #yiv3094694492actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3094694492
#yiv3094694492activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3094694492
#yiv3094694492activity span {font-weight:700;}#yiv3094694492
#yiv3094694492activity span:first-child
{text-transform:uppercase;}#yiv3094694492 #yiv3094694492activity span a
{color:#5085b6;text-decoration:none;}#yiv3094694492 #yiv3094694492activity span
span {color:#ff7900;}#yiv3094694492 #yiv3094694492activity span
.yiv3094694492underline {text-decoration:underline;}#yiv3094694492
.yiv3094694492attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3094694492 .yiv3094694492attach div a
{text-decoration:none;}#yiv3094694492 .yiv3094694492attach img
{border:none;padding-right:5px;}#yiv3094694492 .yiv3094694492attach label
{display:block;margin-bottom:5px;}#yiv3094694492 .yiv3094694492attach label a
{text-decoration:none;}#yiv3094694492 blockquote {margin:0 0 0
4px;}#yiv3094694492 .yiv3094694492bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3094694492
.yiv3094694492bold a {text-decoration:none;}#yiv3094694492 dd.yiv3094694492last
p a {font-family:Verdana;font-weight:700;}#yiv3094694492 dd.yiv3094694492last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3094694492
dd.yiv3094694492last p span.yiv3094694492yshortcuts
{margin-right:0;}#yiv3094694492 div.yiv3094694492attach-table div div a
{text-decoration:none;}#yiv3094694492 div.yiv3094694492attach-table
{width:400px;}#yiv3094694492 div.yiv3094694492file-title a, #yiv3094694492
div.yiv3094694492file-title a:active, #yiv3094694492
div.yiv3094694492file-title a:hover, #yiv3094694492 div.yiv3094694492file-title
a:visited {text-decoration:none;}#yiv3094694492 div.yiv3094694492photo-title a,
#yiv3094694492 div.yiv3094694492photo-title a:active, #yiv3094694492
div.yiv3094694492photo-title a:hover, #yiv3094694492
div.yiv3094694492photo-title a:visited {text-decoration:none;}#yiv3094694492
div#yiv3094694492ygrp-mlmsg #yiv3094694492ygrp-msg p a
span.yiv3094694492yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3094694492
.yiv3094694492green {color:#628c2a;}#yiv3094694492 .yiv3094694492MsoNormal
{margin:0 0 0 0;}#yiv3094694492 o {font-size:0;}#yiv3094694492
#yiv3094694492photos div {float:left;width:72px;}#yiv3094694492
#yiv3094694492photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3094694492
#yiv3094694492photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3094694492
#yiv3094694492reco-category {font-size:77%;}#yiv3094694492
#yiv3094694492reco-desc {font-size:77%;}#yiv3094694492 .yiv3094694492replbq
{margin:4px;}#yiv3094694492 #yiv3094694492ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3094694492 #yiv3094694492ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3094694492
#yiv3094694492ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3094694492
#yiv3094694492ygrp-mlmsg select, #yiv3094694492 input, #yiv3094694492 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3094694492
#yiv3094694492ygrp-mlmsg pre, #yiv3094694492 code {font:115%
monospace;}#yiv3094694492 #yiv3094694492ygrp-mlmsg *
{line-height:1.22em;}#yiv3094694492 #yiv3094694492ygrp-mlmsg #yiv3094694492logo
{padding-bottom:10px;}#yiv3094694492 #yiv3094694492ygrp-msg p a
{font-family:Verdana;}#yiv3094694492 #yiv3094694492ygrp-msg
p#yiv3094694492attach-count span {color:#1E66AE;font-weight:700;}#yiv3094694492
#yiv3094694492ygrp-reco #yiv3094694492reco-head
{color:#ff7900;font-weight:700;}#yiv3094694492 #yiv3094694492ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3094694492 #yiv3094694492ygrp-sponsor
#yiv3094694492ov li a {font-size:130%;text-decoration:none;}#yiv3094694492
#yiv3094694492ygrp-sponsor #yiv3094694492ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3094694492
#yiv3094694492ygrp-sponsor #yiv3094694492ov ul {margin:0;padding:0 0 0
8px;}#yiv3094694492 #yiv3094694492ygrp-text
{font-family:Georgia;}#yiv3094694492 #yiv3094694492ygrp-text p {margin:0 0 1em
0;}#yiv3094694492 #yiv3094694492ygrp-text tt {font-size:120%;}#yiv3094694492
#yiv3094694492ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3094694492
