Assalamualaikum
Mr.Kid
Terimakasih Banyak pencerahannya
Wassalamualaikum
Pada Selasa, 18 Oktober 2016 12:04, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Hai Hairul,
Sila lihat trit yang ini :
https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/40985
dan terapkan dengan Index yang telah ditentukan nomor indeks baris dan nomor
indeks kolom yang dibutuhkan yang merujuk ke area data yang ditunjuk (bahasa
sederhananya, manfaatkan fungsi Index dengan baik, bila perlu, pelajari dengan
sungguh-sungguh lebih dahulu tentang fungsi Index)
Wassalamu'alaikum wr wb
Kid
2016-10-18 10:25 GMT+07:00 HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]>:
Yth.Para Master
Assalamualaikum
Mohon Pencerahannya,Saya memiliki masalah Excel tentang look up gambar dengan 2
criteria vertical & horisontal lookup.. seperti data terlampir
Wassalamualaikum
Terimakasih
Hairul Alam
#yiv3030506462 #yiv3030506462 -- #yiv3030506462ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3030506462
#yiv3030506462ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3030506462
#yiv3030506462ygrp-mkp #yiv3030506462hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3030506462 #yiv3030506462ygrp-mkp #yiv3030506462ads
{margin-bottom:10px;}#yiv3030506462 #yiv3030506462ygrp-mkp .yiv3030506462ad
{padding:0 0;}#yiv3030506462 #yiv3030506462ygrp-mkp .yiv3030506462ad p
{margin:0;}#yiv3030506462 #yiv3030506462ygrp-mkp .yiv3030506462ad a
{color:#0000ff;text-decoration:none;}#yiv3030506462 #yiv3030506462ygrp-sponsor
#yiv3030506462ygrp-lc {font-family:Arial;}#yiv3030506462
#yiv3030506462ygrp-sponsor #yiv3030506462ygrp-lc #yiv3030506462hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3030506462
#yiv3030506462ygrp-sponsor #yiv3030506462ygrp-lc .yiv3030506462ad
{margin-bottom:10px;padding:0 0;}#yiv3030506462 #yiv3030506462actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3030506462
#yiv3030506462activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3030506462
#yiv3030506462activity span {font-weight:700;}#yiv3030506462
#yiv3030506462activity span:first-child
{text-transform:uppercase;}#yiv3030506462 #yiv3030506462activity span a
{color:#5085b6;text-decoration:none;}#yiv3030506462 #yiv3030506462activity span
span {color:#ff7900;}#yiv3030506462 #yiv3030506462activity span
.yiv3030506462underline {text-decoration:underline;}#yiv3030506462
.yiv3030506462attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3030506462 .yiv3030506462attach div a
{text-decoration:none;}#yiv3030506462 .yiv3030506462attach img
{border:none;padding-right:5px;}#yiv3030506462 .yiv3030506462attach label
{display:block;margin-bottom:5px;}#yiv3030506462 .yiv3030506462attach label a
{text-decoration:none;}#yiv3030506462 blockquote {margin:0 0 0
4px;}#yiv3030506462 .yiv3030506462bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3030506462
.yiv3030506462bold a {text-decoration:none;}#yiv3030506462 dd.yiv3030506462last
p a {font-family:Verdana;font-weight:700;}#yiv3030506462 dd.yiv3030506462last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3030506462
dd.yiv3030506462last p span.yiv3030506462yshortcuts
{margin-right:0;}#yiv3030506462 div.yiv3030506462attach-table div div a
{text-decoration:none;}#yiv3030506462 div.yiv3030506462attach-table
{width:400px;}#yiv3030506462 div.yiv3030506462file-title a, #yiv3030506462
div.yiv3030506462file-title a:active, #yiv3030506462
div.yiv3030506462file-title a:hover, #yiv3030506462 div.yiv3030506462file-title
a:visited {text-decoration:none;}#yiv3030506462 div.yiv3030506462photo-title a,
#yiv3030506462 div.yiv3030506462photo-title a:active, #yiv3030506462
div.yiv3030506462photo-title a:hover, #yiv3030506462
div.yiv3030506462photo-title a:visited {text-decoration:none;}#yiv3030506462
div#yiv3030506462ygrp-mlmsg #yiv3030506462ygrp-msg p a
span.yiv3030506462yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3030506462
.yiv3030506462green {color:#628c2a;}#yiv3030506462 .yiv3030506462MsoNormal
{margin:0 0 0 0;}#yiv3030506462 o {font-size:0;}#yiv3030506462
#yiv3030506462photos div {float:left;width:72px;}#yiv3030506462
#yiv3030506462photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3030506462
#yiv3030506462photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3030506462
#yiv3030506462reco-category {font-size:77%;}#yiv3030506462
#yiv3030506462reco-desc {font-size:77%;}#yiv3030506462 .yiv3030506462replbq
{margin:4px;}#yiv3030506462 #yiv3030506462ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3030506462 #yiv3030506462ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3030506462
#yiv3030506462ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3030506462
#yiv3030506462ygrp-mlmsg select, #yiv3030506462 input, #yiv3030506462 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3030506462
#yiv3030506462ygrp-mlmsg pre, #yiv3030506462 code {font:115%
monospace;}#yiv3030506462 #yiv3030506462ygrp-mlmsg *
{line-height:1.22em;}#yiv3030506462 #yiv3030506462ygrp-mlmsg #yiv3030506462logo
{padding-bottom:10px;}#yiv3030506462 #yiv3030506462ygrp-msg p a
{font-family:Verdana;}#yiv3030506462 #yiv3030506462ygrp-msg
p#yiv3030506462attach-count span {color:#1E66AE;font-weight:700;}#yiv3030506462
#yiv3030506462ygrp-reco #yiv3030506462reco-head
{color:#ff7900;font-weight:700;}#yiv3030506462 #yiv3030506462ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3030506462 #yiv3030506462ygrp-sponsor
#yiv3030506462ov li a {font-size:130%;text-decoration:none;}#yiv3030506462
#yiv3030506462ygrp-sponsor #yiv3030506462ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3030506462
#yiv3030506462ygrp-sponsor #yiv3030506462ov ul {margin:0;padding:0 0 0
8px;}#yiv3030506462 #yiv3030506462ygrp-text
{font-family:Georgia;}#yiv3030506462 #yiv3030506462ygrp-text p {margin:0 0 1em
0;}#yiv3030506462 #yiv3030506462ygrp-text tt {font-size:120%;}#yiv3030506462
#yiv3030506462ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3030506462
