Dear Mr. Kid
Terima kasih atas bantuannya, Saya akan coba pelajari. Wassalam Rudhie Pada Jumat, 14 Oktober 2016 12:51, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Rudhie, Formula lookup picture ya. Coba file yang ada disini. Regards, Kid 2016-10-14 8:55 GMT+07:00 Rudhie rudhied...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: Dear Be Exceller Selamat Pagi Saya ingin menanyakan "Bagaimanakah cara di excel untuk menampilkan picture tanpa menggunakan VBA / macro ? tetapi dibuat dengan menggunakan formula dan define picture ?". Sebelumnya saya sudah mencoba file yang pernah di download di milis ini, tetapi file di protect dan tidak ada cara atau penjelasan langkah-langkahnya. Saya sudah mencoba, tetapi kurang paham langkah-langkahnya. Mohon kiranya Be Exceller dapat memberikan pencerahannya beserta contoh file yang mudah dan dapat dijelaskan langkah-langkahnya satu per-satu. Terima Kasih Rudhie #yiv2970118883 #yiv2970118883 -- #yiv2970118883ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2970118883 #yiv2970118883ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2970118883 #yiv2970118883ygrp-mkp #yiv2970118883hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2970118883 #yiv2970118883ygrp-mkp #yiv2970118883ads {margin-bottom:10px;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad {padding:0 0;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad p {margin:0;}#yiv2970118883 #yiv2970118883ygrp-mkp .yiv2970118883ad a {color:#0000ff;text-decoration:none;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ygrp-lc {font-family:Arial;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ygrp-lc #yiv2970118883hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ygrp-lc .yiv2970118883ad {margin-bottom:10px;padding:0 0;}#yiv2970118883 #yiv2970118883actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2970118883 #yiv2970118883activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2970118883 #yiv2970118883activity span {font-weight:700;}#yiv2970118883 #yiv2970118883activity span:first-child {text-transform:uppercase;}#yiv2970118883 #yiv2970118883activity span a {color:#5085b6;text-decoration:none;}#yiv2970118883 #yiv2970118883activity span span {color:#ff7900;}#yiv2970118883 #yiv2970118883activity span .yiv2970118883underline {text-decoration:underline;}#yiv2970118883 .yiv2970118883attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2970118883 .yiv2970118883attach div a {text-decoration:none;}#yiv2970118883 .yiv2970118883attach img {border:none;padding-right:5px;}#yiv2970118883 .yiv2970118883attach label {display:block;margin-bottom:5px;}#yiv2970118883 .yiv2970118883attach label a {text-decoration:none;}#yiv2970118883 blockquote {margin:0 0 0 4px;}#yiv2970118883 .yiv2970118883bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2970118883 .yiv2970118883bold a {text-decoration:none;}#yiv2970118883 dd.yiv2970118883last p a {font-family:Verdana;font-weight:700;}#yiv2970118883 dd.yiv2970118883last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2970118883 dd.yiv2970118883last p span.yiv2970118883yshortcuts {margin-right:0;}#yiv2970118883 div.yiv2970118883attach-table div div a {text-decoration:none;}#yiv2970118883 div.yiv2970118883attach-table {width:400px;}#yiv2970118883 div.yiv2970118883file-title a, #yiv2970118883 div.yiv2970118883file-title a:active, #yiv2970118883 div.yiv2970118883file-title a:hover, #yiv2970118883 div.yiv2970118883file-title a:visited {text-decoration:none;}#yiv2970118883 div.yiv2970118883photo-title a, #yiv2970118883 div.yiv2970118883photo-title a:active, #yiv2970118883 div.yiv2970118883photo-title a:hover, #yiv2970118883 div.yiv2970118883photo-title a:visited {text-decoration:none;}#yiv2970118883 div#yiv2970118883ygrp-mlmsg #yiv2970118883ygrp-msg p a span.yiv2970118883yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2970118883 .yiv2970118883green {color:#628c2a;}#yiv2970118883 .yiv2970118883MsoNormal {margin:0 0 0 0;}#yiv2970118883 o {font-size:0;}#yiv2970118883 #yiv2970118883photos div {float:left;width:72px;}#yiv2970118883 #yiv2970118883photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2970118883 #yiv2970118883photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2970118883 #yiv2970118883reco-category {font-size:77%;}#yiv2970118883 #yiv2970118883reco-desc {font-size:77%;}#yiv2970118883 .yiv2970118883replbq {margin:4px;}#yiv2970118883 #yiv2970118883ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2970118883 #yiv2970118883ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2970118883 #yiv2970118883ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2970118883 #yiv2970118883ygrp-mlmsg select, #yiv2970118883 input, #yiv2970118883 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2970118883 #yiv2970118883ygrp-mlmsg pre, #yiv2970118883 code {font:115% monospace;}#yiv2970118883 #yiv2970118883ygrp-mlmsg * {line-height:1.22em;}#yiv2970118883 #yiv2970118883ygrp-mlmsg #yiv2970118883logo {padding-bottom:10px;}#yiv2970118883 #yiv2970118883ygrp-msg p a {font-family:Verdana;}#yiv2970118883 #yiv2970118883ygrp-msg p#yiv2970118883attach-count span {color:#1E66AE;font-weight:700;}#yiv2970118883 #yiv2970118883ygrp-reco #yiv2970118883reco-head {color:#ff7900;font-weight:700;}#yiv2970118883 #yiv2970118883ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ov li a {font-size:130%;text-decoration:none;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2970118883 #yiv2970118883ygrp-sponsor #yiv2970118883ov ul {margin:0;padding:0 0 0 8px;}#yiv2970118883 #yiv2970118883ygrp-text {font-family:Georgia;}#yiv2970118883 #yiv2970118883ygrp-text p {margin:0 0 1em 0;}#yiv2970118883 #yiv2970118883ygrp-text tt {font-size:120%;}#yiv2970118883 #yiv2970118883ygrp-vital ul li:last-child {border-right:none !important;}#yiv2970118883