Berikut saya kirimkan kembali file contoh dengan data lebih dinamis. Terima kasih
On Tuesday, October 7, 2014 5:45 PM, ris ha <[email protected]> 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 [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
#yiv1636737928 -- #yiv1636737928ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1636737928
#yiv1636737928ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1636737928
#yiv1636737928ygrp-mkp #yiv1636737928hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1636737928 #yiv1636737928ygrp-mkp #yiv1636737928ads
{margin-bottom:10px;}#yiv1636737928 #yiv1636737928ygrp-mkp .yiv1636737928ad
{padding:0 0;}#yiv1636737928 #yiv1636737928ygrp-mkp .yiv1636737928ad p
{margin:0;}#yiv1636737928 #yiv1636737928ygrp-mkp .yiv1636737928ad a
{color:#0000ff;text-decoration:none;}#yiv1636737928 #yiv1636737928ygrp-sponsor
#yiv1636737928ygrp-lc {font-family:Arial;}#yiv1636737928
#yiv1636737928ygrp-sponsor #yiv1636737928ygrp-lc #yiv1636737928hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1636737928
#yiv1636737928ygrp-sponsor #yiv1636737928ygrp-lc .yiv1636737928ad
{margin-bottom:10px;padding:0 0;}#yiv1636737928 #yiv1636737928actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1636737928
#yiv1636737928activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1636737928
#yiv1636737928activity span {font-weight:700;}#yiv1636737928
#yiv1636737928activity span:first-child
{text-transform:uppercase;}#yiv1636737928 #yiv1636737928activity span a
{color:#5085b6;text-decoration:none;}#yiv1636737928 #yiv1636737928activity span
span {color:#ff7900;}#yiv1636737928 #yiv1636737928activity span
.yiv1636737928underline {text-decoration:underline;}#yiv1636737928
.yiv1636737928attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1636737928 .yiv1636737928attach div a
{text-decoration:none;}#yiv1636737928 .yiv1636737928attach img
{border:none;padding-right:5px;}#yiv1636737928 .yiv1636737928attach label
{display:block;margin-bottom:5px;}#yiv1636737928 .yiv1636737928attach label a
{text-decoration:none;}#yiv1636737928 blockquote {margin:0 0 0
4px;}#yiv1636737928 .yiv1636737928bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1636737928
.yiv1636737928bold a {text-decoration:none;}#yiv1636737928 dd.yiv1636737928last
p a {font-family:Verdana;font-weight:700;}#yiv1636737928 dd.yiv1636737928last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1636737928
dd.yiv1636737928last p span.yiv1636737928yshortcuts
{margin-right:0;}#yiv1636737928 div.yiv1636737928attach-table div div a
{text-decoration:none;}#yiv1636737928 div.yiv1636737928attach-table
{width:400px;}#yiv1636737928 div.yiv1636737928file-title a, #yiv1636737928
div.yiv1636737928file-title a:active, #yiv1636737928
div.yiv1636737928file-title a:hover, #yiv1636737928 div.yiv1636737928file-title
a:visited {text-decoration:none;}#yiv1636737928 div.yiv1636737928photo-title a,
#yiv1636737928 div.yiv1636737928photo-title a:active, #yiv1636737928
div.yiv1636737928photo-title a:hover, #yiv1636737928
div.yiv1636737928photo-title a:visited {text-decoration:none;}#yiv1636737928
div#yiv1636737928ygrp-mlmsg #yiv1636737928ygrp-msg p a
span.yiv1636737928yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1636737928
.yiv1636737928green {color:#628c2a;}#yiv1636737928 .yiv1636737928MsoNormal
{margin:0 0 0 0;}#yiv1636737928 o {font-size:0;}#yiv1636737928
#yiv1636737928photos div {float:left;width:72px;}#yiv1636737928
#yiv1636737928photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1636737928
#yiv1636737928photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1636737928
#yiv1636737928reco-category {font-size:77%;}#yiv1636737928
#yiv1636737928reco-desc {font-size:77%;}#yiv1636737928 .yiv1636737928replbq
{margin:4px;}#yiv1636737928 #yiv1636737928ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1636737928 #yiv1636737928ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1636737928
#yiv1636737928ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1636737928
#yiv1636737928ygrp-mlmsg select, #yiv1636737928 input, #yiv1636737928 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1636737928
#yiv1636737928ygrp-mlmsg pre, #yiv1636737928 code {font:115%
monospace;}#yiv1636737928 #yiv1636737928ygrp-mlmsg *
{line-height:1.22em;}#yiv1636737928 #yiv1636737928ygrp-mlmsg #yiv1636737928logo
{padding-bottom:10px;}#yiv1636737928 #yiv1636737928ygrp-msg p a
{font-family:Verdana;}#yiv1636737928 #yiv1636737928ygrp-msg
p#yiv1636737928attach-count span {color:#1E66AE;font-weight:700;}#yiv1636737928
#yiv1636737928ygrp-reco #yiv1636737928reco-head
{color:#ff7900;font-weight:700;}#yiv1636737928 #yiv1636737928ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1636737928 #yiv1636737928ygrp-sponsor
#yiv1636737928ov li a {font-size:130%;text-decoration:none;}#yiv1636737928
#yiv1636737928ygrp-sponsor #yiv1636737928ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1636737928
#yiv1636737928ygrp-sponsor #yiv1636737928ov ul {margin:0;padding:0 0 0
8px;}#yiv1636737928 #yiv1636737928ygrp-text
{font-family:Georgia;}#yiv1636737928 #yiv1636737928ygrp-text p {margin:0 0 1em
0;}#yiv1636737928 #yiv1636737928ygrp-text tt {font-size:120%;}#yiv1636737928
#yiv1636737928ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1636737928
VLOOKUP KANAN KIRI revisi.xlsx
Description: MS-Excel 2007 spreadsheet
