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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected] [belajar-excel]
<[email protected]>:
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
#yiv7941682969 #yiv7941682969 -- #yiv7941682969ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7941682969
#yiv7941682969ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7941682969
#yiv7941682969ygrp-mkp #yiv7941682969hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7941682969 #yiv7941682969ygrp-mkp #yiv7941682969ads
{margin-bottom:10px;}#yiv7941682969 #yiv7941682969ygrp-mkp .yiv7941682969ad
{padding:0 0;}#yiv7941682969 #yiv7941682969ygrp-mkp .yiv7941682969ad p
{margin:0;}#yiv7941682969 #yiv7941682969ygrp-mkp .yiv7941682969ad a
{color:#0000ff;text-decoration:none;}#yiv7941682969 #yiv7941682969ygrp-sponsor
#yiv7941682969ygrp-lc {font-family:Arial;}#yiv7941682969
#yiv7941682969ygrp-sponsor #yiv7941682969ygrp-lc #yiv7941682969hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7941682969
#yiv7941682969ygrp-sponsor #yiv7941682969ygrp-lc .yiv7941682969ad
{margin-bottom:10px;padding:0 0;}#yiv7941682969 #yiv7941682969actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7941682969
#yiv7941682969activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7941682969
#yiv7941682969activity span {font-weight:700;}#yiv7941682969
#yiv7941682969activity span:first-child
{text-transform:uppercase;}#yiv7941682969 #yiv7941682969activity span a
{color:#5085b6;text-decoration:none;}#yiv7941682969 #yiv7941682969activity span
span {color:#ff7900;}#yiv7941682969 #yiv7941682969activity span
.yiv7941682969underline {text-decoration:underline;}#yiv7941682969
.yiv7941682969attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7941682969 .yiv7941682969attach div a
{text-decoration:none;}#yiv7941682969 .yiv7941682969attach img
{border:none;padding-right:5px;}#yiv7941682969 .yiv7941682969attach label
{display:block;margin-bottom:5px;}#yiv7941682969 .yiv7941682969attach label a
{text-decoration:none;}#yiv7941682969 blockquote {margin:0 0 0
4px;}#yiv7941682969 .yiv7941682969bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7941682969
.yiv7941682969bold a {text-decoration:none;}#yiv7941682969 dd.yiv7941682969last
p a {font-family:Verdana;font-weight:700;}#yiv7941682969 dd.yiv7941682969last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7941682969
dd.yiv7941682969last p span.yiv7941682969yshortcuts
{margin-right:0;}#yiv7941682969 div.yiv7941682969attach-table div div a
{text-decoration:none;}#yiv7941682969 div.yiv7941682969attach-table
{width:400px;}#yiv7941682969 div.yiv7941682969file-title a, #yiv7941682969
div.yiv7941682969file-title a:active, #yiv7941682969
div.yiv7941682969file-title a:hover, #yiv7941682969 div.yiv7941682969file-title
a:visited {text-decoration:none;}#yiv7941682969 div.yiv7941682969photo-title a,
#yiv7941682969 div.yiv7941682969photo-title a:active, #yiv7941682969
div.yiv7941682969photo-title a:hover, #yiv7941682969
div.yiv7941682969photo-title a:visited {text-decoration:none;}#yiv7941682969
div#yiv7941682969ygrp-mlmsg #yiv7941682969ygrp-msg p a
span.yiv7941682969yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7941682969
.yiv7941682969green {color:#628c2a;}#yiv7941682969 .yiv7941682969MsoNormal
{margin:0 0 0 0;}#yiv7941682969 o {font-size:0;}#yiv7941682969
#yiv7941682969photos div {float:left;width:72px;}#yiv7941682969
#yiv7941682969photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7941682969
#yiv7941682969photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7941682969
#yiv7941682969reco-category {font-size:77%;}#yiv7941682969
#yiv7941682969reco-desc {font-size:77%;}#yiv7941682969 .yiv7941682969replbq
{margin:4px;}#yiv7941682969 #yiv7941682969ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7941682969 #yiv7941682969ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7941682969
#yiv7941682969ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7941682969
#yiv7941682969ygrp-mlmsg select, #yiv7941682969 input, #yiv7941682969 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7941682969
#yiv7941682969ygrp-mlmsg pre, #yiv7941682969 code {font:115%
monospace;}#yiv7941682969 #yiv7941682969ygrp-mlmsg *
{line-height:1.22em;}#yiv7941682969 #yiv7941682969ygrp-mlmsg #yiv7941682969logo
{padding-bottom:10px;}#yiv7941682969 #yiv7941682969ygrp-msg p a
{font-family:Verdana;}#yiv7941682969 #yiv7941682969ygrp-msg
p#yiv7941682969attach-count span {color:#1E66AE;font-weight:700;}#yiv7941682969
#yiv7941682969ygrp-reco #yiv7941682969reco-head
{color:#ff7900;font-weight:700;}#yiv7941682969 #yiv7941682969ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7941682969 #yiv7941682969ygrp-sponsor
#yiv7941682969ov li a {font-size:130%;text-decoration:none;}#yiv7941682969
#yiv7941682969ygrp-sponsor #yiv7941682969ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7941682969
#yiv7941682969ygrp-sponsor #yiv7941682969ov ul {margin:0;padding:0 0 0
8px;}#yiv7941682969 #yiv7941682969ygrp-text
{font-family:Georgia;}#yiv7941682969 #yiv7941682969ygrp-text p {margin:0 0 1em
0;}#yiv7941682969 #yiv7941682969ygrp-text tt {font-size:120%;}#yiv7941682969
#yiv7941682969ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7941682969
